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
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

@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

@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.

@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)

 

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!

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

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
16 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
11 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies