Looks like no one’s replied in a while. To start the conversation again, simply ask a new question.

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)

Posted on Aug 31, 2022 5:21 PM

Reply
Question marked as Top-ranking reply

Posted on Aug 31, 2022 6:54 PM

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.

4 replies
Sort By: 
Question marked as Top-ranking reply

Aug 31, 2022 6:54 PM in response to HayleyHatzi

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.

Reply

Aug 31, 2022 6:32 PM in response to HayleyHatzi


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.

Reply

Syntax error

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple Account.