Hi folks,
Trying to write an IF statement in Excel for iOS but Excel doesn’t seem to see the comparator as text. The formula is
=IF(A6=“ITEM”,1,0)
which gives a #NAME? error. If I change the formula to
=IF(A6=3,1,0)
then the formula works. I’ve tried replacing the “ round Item with ‘ to no avail.
I’ve also replicated the example on the MS Excel website (which uses “) and get the same error.
iPad Mini 5, iOS 12.4, Excel 2.28
Thanks
Fraser
It is because you are using curly quotes and Excel requires quotes.
The default on the iPad (since iOS 11 apparently) is curly “ so to get non-curly hold down the “ key and move to ".
So try =IF(A6="ITEM",1,0)
It is because you are using curly quotes and Excel requires quotes.
The default on the iPad (since iOS 11 apparently) is curly “ so to get non-curly hold down the “ key and move to ".
So try =IF(A6="ITEM",1,0)
Soooo.....
I opened the spreadsheet on a PC and got the same result, but:
the “ looked a bit strange (the left “ looked inverted compared to the right ”) so I retyped the formula in the cell underneath and the ‘Windows’ quote marks were different to the iPad ones (the left and right were the same) and .... the formula worked.
There’s possibly an option to change the default iOS character set - changing the spreadsheet font on the PC didn’t make any difference.
Hope this helps.
I admit I have not used Excel in eight years. (I now use Apple’s Numbers.)
But from my recollection:
F_Mac wrote:
I’ve tried replacing the “ round Item with ‘ to no avail.
Try replacing the double quote quote with a pair of double quotes:
=IF(A6=“”ITEM””,1,0)
Thanks, unfortunately it didn’t work.
Thanks, this didn’t work either butI appreciate the suggestions you’ve both offered.
Hi, THANKS, appreciate you taking the time to post this!
I learnt something myself. There is no need to use the shift key, simply hold down the ‘ key to get the Excel " double quote. (At least on the UK keyboard).
Double THANKS 🙏🏼
I don't use Excel much either, but the following works in the current version of Excel on my Mac:
=IF(A6 = "ITEM",1,0)
The difference from your example, which did not work on my Mac, is the spaces before and after the =.
Excel IF statement not recognising text
