SOLVED
Home

IF FUNCTION ISN'T WORKING NO MATTER HOW SIMPLE THE COMMAND IS

%3CLINGO-SUB%20id%3D%22lingo-sub-377628%22%20slang%3D%22en-US%22%3EIF%20FUNCTION%20ISN'T%20WORKING%20NO%20MATTER%20HOW%20SIMPLE%20THE%20COMMAND%20IS%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-377628%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%20I%20was%20trying%20to%20use%20the%20IF%20function%20and%20it%20wasn't%20working%20so%20i%20tried%20to%20make%20it%20as%20simple%20as%20possible%20to%20see%20what%20the%20problem%20was.%20Still%2C%20it%20gave%20me%20an%20error%20even%20though%20I%20just%20copied%20and%20pasted%20the%20formula%20from%20windows%20support%20page%20so%20I%20don't%20really%20know%20what%20to%20do.%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F93950i0A1E29B48CA7147D%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22problem%20excel%202.JPG%22%20title%3D%22problem%20excel%202.JPG%22%20%2F%3E%3C%2FSPAN%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20828px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F93949i4AD95FE717060D6E%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22problem%20excel.JPG%22%20title%3D%22problem%20excel.JPG%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-377628%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3Eif%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3Esimple%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-377851%22%20slang%3D%22en-US%22%3ERe%3A%20IF%20FUNCTION%20ISN'T%20WORKING%20NO%20MATTER%20HOW%20SIMPLE%20THE%20COMMAND%20IS%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-377851%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F304454%22%20target%3D%22_blank%22%3E%40thomasea%3C%2FA%3E%26nbsp%3B%2C%20glad%20to%20help%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-377755%22%20slang%3D%22en-US%22%3ERe%3A%20IF%20FUNCTION%20ISN'T%20WORKING%20NO%20MATTER%20HOW%20SIMPLE%20THE%20COMMAND%20IS%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-377755%22%20slang%3D%22en-US%22%3E%3CP%3Ei%20already%20did%20it%20but%20as%20%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%20said%20it%20was%20about%20typing%20semicolons%20instead%20of%20commas%2C%20but%20thanks%20anyway%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F280482%22%20target%3D%22_blank%22%3E%40Twifoo%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-377753%22%20slang%3D%22en-US%22%3ERe%3A%20IF%20FUNCTION%20ISN'T%20WORKING%20NO%20MATTER%20HOW%20SIMPLE%20THE%20COMMAND%20IS%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-377753%22%20slang%3D%22en-US%22%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CBLOCKQUOTE%3E%3CHR%20%2F%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%3Bwrote%3A%3CBR%20%2F%3E%3CP%3EPerhaps%20your%20list%20separator%20is%20not%20comma%20(e.g.%20semicolon).%20You%20may%20check%20Win%2BR%20type%20%3CSTRONG%3Econtrol%20international%3C%2FSTRONG%3E%20and%20here%20is%20under%20Additional%20settings%3C%2FP%3E%3CHR%20%2F%3E%3C%2FBLOCKQUOTE%3E%3CP%3E%3CBR%20%2F%3Ethanks%20a%20lot%20it%20really%20worked%20%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%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-377709%22%20slang%3D%22en-US%22%3ERe%3A%20IF%20FUNCTION%20ISN'T%20WORKING%20NO%20MATTER%20HOW%20SIMPLE%20THE%20COMMAND%20IS%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-377709%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F280482%22%20target%3D%22_blank%22%3E%40Twifoo%3C%2FA%3E%26nbsp%3BI%20believe%20this%20is%20the%20issue%20as%20well.%20Those%20quote%20marks%20look%20like%20smart%20quotes%20(curved%20quote%20marks)%20rather%20than%20proper%20actual%20quotation%20marks%2C%20which%20will%20break%20formulas%20in%20Excel%20(or%20nearly%20any%20programming%20language).%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-377698%22%20slang%3D%22en-US%22%3ERe%3A%20IF%20FUNCTION%20ISN'T%20WORKING%20NO%20MATTER%20HOW%20SIMPLE%20THE%20COMMAND%20IS%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-377698%22%20slang%3D%22en-US%22%3E%3CP%3EPerhaps%20your%20list%20separator%20is%20not%20comma%20(e.g.%20semicolon).%20You%20may%20check%20Win%2BR%20type%20%3CSTRONG%3Econtrol%20international%3C%2FSTRONG%3E%20and%20here%20is%20under%20Additional%20settings%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-377647%22%20slang%3D%22en-US%22%3ERe%3A%20IF%20FUNCTION%20ISN'T%20WORKING%20NO%20MATTER%20HOW%20SIMPLE%20THE%20COMMAND%20IS%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-377647%22%20slang%3D%22en-US%22%3ETry%20to%20type%20the%20formula%20rather%20than%20copy%20and%20paste%20it.%3C%2FLINGO-BODY%3E
thomasea
New Contributor

Hi, I was trying to use the IF function and it wasn't working so i tried to make it as simple as possible to see what the problem was. Still, it gave me an error even though I just copied and pasted the formula from windows support page so I don't really know what to do.

problem excel 2.JPGproblem excel.JPG

6 Replies
Try to type the formula rather than copy and paste it.
Solution

Perhaps your list separator is not comma (e.g. semicolon). You may check Win+R type control international and here is under Additional settings

@Twifoo I believe this is the issue as well. Those quote marks look like smart quotes (curved quote marks) rather than proper actual quotation marks, which will break formulas in Excel (or nearly any programming language).

 


@Sergei Baklan wrote:

Perhaps your list separator is not comma (e.g. semicolon). You may check Win+R type control international and here is under Additional settings



thanks a lot it really worked @Sergei Baklan 

i already did it but as @Sergei Baklan said it was about typing semicolons instead of commas, but thanks anyway@Twifoo 

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
30 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies