Forum Discussion
My excel in office 365 on iPad does not understand a simple formula
SergeiBaklan you have pointed me in the right direction of solving this problem.
What looked like a double quote was not one. The solution that works for me is to uncheck the "Smart punctuation", which seems to be the default of a new installation of iOS, found under Setting->General->Keyboards of iOS.
Tested and working!
That's nothing specific for iPad, any version of Excel returns #NAME? error if you use " CHAR(148) instead of " CHAR(34). If check for the explanation that will be unrecognized text
Exactly the same effect, if, for example, type
=IF(A2=abcde,1,0)
SergeiBaklan you have pointed me in the right direction of solving this problem.
What looked like a double quote was not one. The solution that works for me is to uncheck the "Smart punctuation", which seems to be the default of a new installation of iOS, found under Setting->General->Keyboards of iOS.
Tested and working!
MickeNy , have no experience with iPad, that's great to know you found the right solution