Syntax error
Hi there,
I'm not sure where my error is. I know there is an extra ,", after Print - screen, however when I remove it the cell C21 is removed from the bubble. What am I missing?
iMac (24-inch, M1, 2021, 2 ports)
Hi there,
I'm not sure where my error is. I know there is an extra ,", after Print - screen, however when I remove it the cell C21 is removed from the bubble. What am I missing?
iMac (24-inch, M1, 2021, 2 ports)
If what you did was remove the ", ", then you did not follow what I posted. That is not what I did. Look more closely at the difference between what you had and what I changed it to.
It may still have another problem that I did not see but hopefully fixing this one will do it.
If what you did was remove the ", ", then you did not follow what I posted. That is not what I did. Look more closely at the difference between what you had and what I changed it to.
It may still have another problem that I did not see but hopefully fixing this one will do it.
It is in this piece of the formula.
Instead of C21="Print - Screen, "165 degrees", ",
should be C21="Print - Screen", "165 degrees",
You do not need the IFERROR if you add to the IFS a final ifs-expression of TRUE and final ifs-true of "" . It becomes the result if none of the other conditions are met and there will be no error to catch.
Thank you for your reply. As soon as I remove the ",", the C21 bubble disappears. No matter how I try to remove/change it, it puts the "," back. There is still an error.
Thank you so much. You are very cleaver!
Syntax error