IFS formula is not recognising $.
I use the IFS formula all the time, but for some reason I am either doing something wrong or the IFS formula doesn’t work with $ symbol?
The screen shot below shows the same formula in both rows, one row does exactly what it should, the other shows an error. What am I missing?
iPad Pro, iPadOS 18
The value in the $50.00 cell is treated as the number 50, with the dollar sign part of the formatting, instead of text. Replace the values in the last two tests with 50 and 100.
(262383)
The value in the $50.00 cell is treated as the number 50, with the dollar sign part of the formatting, instead of text. Replace the values in the last two tests with 50 and 100.
(262383)
Note that "replace the values in the last two tests with 50 and 100" includes removing the quotes, too.
Thank you. Works….but as per Badunit below, I had to remove the quotes to make it work.
IFS formula not recognizing dollar sign
