Syntax error

Question

Level 1

7 points

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

Answer 1

Top-ranking reply

Badunit

Level 7

30,348 points

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

Answer 2

Badunit

Level 7

30,348 points

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

Answer 3

HayleyHatzi Author

Level 1

7 points

Aug 31, 2022 6:38 PM in response to Badunit

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.

Reply

Answer 4

HayleyHatzi Author

Level 1

7 points

Aug 31, 2022 8:10 PM in response to Badunit

Thank you so much. You are very cleaver!

Reply