SOLVED
Home

My excel in office 365 on iPad does not understand a simple formula

%3CLINGO-SUB%20id%3D%22lingo-sub-694586%22%20slang%3D%22en-US%22%3EMy%20excel%20in%20office%20365%20on%20iPad%20does%20not%20understand%20a%20simple%20formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-694586%22%20slang%3D%22en-US%22%3E%3CP%3EI%20recently%20purchased%20an%20Office%20365%20license%20and%20downloaded%20the%20latest%20versions%20of%20Excel%20to%20my%20iPad%20Pro%2011%E2%80%9D.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EEarlier%20I%20have%20used%20the%20free%20Excel%20daily%20on%20my%20old%20iPad%204%20with%20no%20hickups.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EToday%20I%20cannot%20get%20Excel%20to%20do%20the%20simple%20task%20of%20comparing%20content%20in%20a%20cell.%3C%2FP%3E%3CP%3EThere%20must%20be%20an%20installation%20trick%20that%20I%20have%20not%20performed%20and%20look%20for%20guidance.%3C%2FP%3E%3CP%3EI%20include%20a%20picture%20displaying%202%20simple%20rows%20where%20the%20first%20one%20works%20fine%3C%2FP%3E%3CP%3Ebut%20the%20second%20one%20produces%20a%20%23NAME%3F%20error%20that%20I%20cannot%20understand.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EPlease%20advice!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-694586%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%20on%20mobile%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-694594%22%20slang%3D%22en-US%22%3ERe%3A%20My%20excel%20in%20office%20365%20on%20iPad%20does%20not%20understand%20a%20simple%20formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-694594%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F361049%22%20target%3D%22_blank%22%3E%40MickeNy%3C%2FA%3E%26nbsp%3Bcan%E2%80%99t%20see%20the%20photo%20so%20here%20is%20the%20content%20of%20it%3A%3C%2FP%3E%3CP%3E1%201%20%E2%80%99%3DIF(A1%3D1%3B1%3B0)%3CBR%20%2F%3EA%20%23NAME%3F%20%E2%80%99%3DIF(A2%3D%E2%80%9DA%E2%80%9D%3B1%3B0)%20Why%20does%20this%20formula%20produce%20the%20error%20in%20cell%20B2%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-696087%22%20slang%3D%22en-US%22%3ERe%3A%20My%20excel%20in%20office%20365%20on%20iPad%20does%20not%20understand%20a%20simple%20formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-696087%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F361049%22%20target%3D%22_blank%22%3E%40MickeNy%3C%2FA%3E%26nbsp%3Bafter%20a%20long%20talk%20with%20MS%20tech%20we%20concluded%20that%20when%20you%20enter%20a%20new%20formula%20that%20contains%20a%20character%20quote%20such%20as%20%E2%80%9Da%E2%80%9D%20then%20the%20error%20code%20%23NAME%3F%20is%20raised.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20condition%20was%20found%20in%20iPad%20office%20365%20excel%20and%20in%20online%20office%20365%20excel.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAn%20error%20report%20has%20been%20submitted%20and%20hopefully%20we%20will%20have%20a%20correction%20shortly.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-698416%22%20slang%3D%22en-US%22%3ERe%3A%20My%20excel%20in%20office%20365%20on%20iPad%20does%20not%20understand%20a%20simple%20formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-698416%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F361049%22%20target%3D%22_blank%22%3E%40MickeNy%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EThat's%20nothing%20specific%20for%20iPad%2C%20any%20version%20of%20Excel%20returns%20%23NAME%3F%20error%20if%20you%20use%20%22%20CHAR(148)%20instead%20of%20%22%20CHAR(34).%20If%20check%20for%20the%20explanation%20that%20will%20be%20unrecognized%20text%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20327px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F119187iE1E894726BA6F851%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22image.png%22%20title%3D%22image.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3EExactly%20the%20same%20effect%2C%20if%2C%20for%20example%2C%20type%3C%2FP%3E%0A%3CPRE%3E%3DIF(A2%3Dabcde%2C1%2C0)%3C%2FPRE%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-698846%22%20slang%3D%22en-US%22%3ERe%3A%20My%20excel%20in%20office%20365%20on%20iPad%20does%20not%20understand%20a%20simple%20formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-698846%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F521%22%20target%3D%22_blank%22%3E%40Sergei%20Baklan%3C%2FA%3E%26nbsp%3Byou%20have%20pointed%20me%20in%20the%20right%20direction%20of%20solving%20this%20problem.%3C%2FP%3E%3CP%3EWhat%20looked%20like%20a%20double%20quote%20was%20not%20one.%20The%20solution%20that%20works%20for%20me%20is%20to%20uncheck%20the%20%22Smart%20punctuation%22%2C%20which%20seems%20to%20be%20the%20default%20of%20a%20new%20installation%20of%20iOS%2C%20found%20under%20Setting-%26gt%3BGeneral-%26gt%3BKeyboards%20of%20iOS.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ETested%20and%20working!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-698963%22%20slang%3D%22en-US%22%3ERe%3A%20My%20excel%20in%20office%20365%20on%20iPad%20does%20not%20understand%20a%20simple%20formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-698963%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F361049%22%20target%3D%22_blank%22%3E%40MickeNy%3C%2FA%3E%26nbsp%3B%2C%20have%20no%20experience%20with%20iPad%2C%20that's%20great%20to%20know%20you%20found%20the%20right%20solution%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
MickeNy
Occasional Contributor

I recently purchased an Office 365 license and downloaded the latest versions of Excel to my iPad Pro 11”.

 

Earlier I have used the free Excel daily on my old iPad 4 with no hickups.

 

Today I cannot get Excel to do the simple task of comparing content in a cell.

There must be an installation trick that I have not performed and look for guidance.

I include a picture displaying 2 simple rows where the first one works fine

but the second one produces a #NAME? error that I cannot understand.

 

Please advice!

 

5 Replies
Highlighted

@MickeNy can’t see the photo so here is the content of it:

1 1 ’=IF(A1=1;1;0)
A #NAME? ’=IF(A2=”A”;1;0) Why does this formula produce the error in cell B2

Highlighted

@MickeNy after a long talk with MS tech we concluded that when you enter a new formula that contains a character quote such as ”a” then the error code #NAME? is raised. 

 

The condition was found in iPad office 365 excel and in online office 365 excel.

 

An error report has been submitted and hopefully we will have a correction shortly.

Highlighted

@MickeNy 

 

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

image.png

Exactly the same effect, if, for example, type

=IF(A2=abcde,1,0)

 

Highlighted
Solution

@Sergei Baklan 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!

Highlighted

@MickeNy , have no experience with iPad, that's great to know you found the right solution

Related Conversations
How to use the trendline to find percentage change?
fishfish31 in Excel on
0 Replies
tableau
Noemie911 in Excel on
4 Replies
Summarzing data
Ravi_Kumar in Excel on
1 Replies
Referencing the data source for a pivot table
RobMacUK in Excel on
1 Replies