IF function

%3CLINGO-SUB%20id%3D%22lingo-sub-1646116%22%20slang%3D%22en-US%22%3EIF%20function%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1646116%22%20slang%3D%22en-US%22%3Ei%20have%20been%20browsing%20the%20internet%20for%20last%202%20hours%20and%20couldnt%20find%20the%20answer.%3CBR%20%2F%3EI%20have%20a%20question%20where%20i%20compare%20numbers%20wich%20return%20results%20accordingly%20in%20true%20or%20false%20wich%20then%20is%20further%20cunted%20how%20many%20falses%20are%20there.%20If%20value%20is%20greater%20than%200%20it%20returns%20false%20no%20problem%20ofcourse.%20The%20problem%20occurs%20when%20i%20want%20it%20to%20type%20put%20not%20ok%20instead%20of%20false.%20The%20whole%20thing%20collapses%20i%20tried%20on%20mobile%20excel%20and%20computer%20nowhere%20seems%20for%20function%20to%20work%20and%20i%20litteraly%20copy%20pasted%20the%20function%20from%20support%20website%20and%20it%20didnt%20work.%3CBR%20%2F%3EThe%20function%20in%20problem%20is%3A%3CBR%20%2F%3EIF(D20%3BD20%26gt%3B0%2C%20%22NotOk%22)%3CBR%20%2F%3EI%20tried%20also%20IF(D20%26gt%3B0%2C%20%22NotOk%22).%3CBR%20%2F%3EI%20am%20very%20aware%20how%20functions%20work%20in%20excel%20i%20just%20cant%20seem%20to%20get%20it%20to%20work%20to%20display%20difirent%20text%20than%20false.%20And%20i%20copy%20pasted%20multiple%20functions%20from%20the%20web.%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1646116%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%3Etraining%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1646198%22%20slang%3D%22en-US%22%3ERe%3A%20IF%20function%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1646198%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F786339%22%20target%3D%22_blank%22%3E%40Kacion%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EThat's%20like%3C%2FP%3E%0A%3CPRE%20class%3D%22lia-code-sample%20language-excel%22%3E%3CCODE%3E%3DIF(D20%26gt%3B0%2C%20%22Perhaps%20Okey%22%2C%20%22Not%20Ok%22)%0A%0A%3DIF(condition%2C%20some%20value%2Fexpression%20if%20TRUE%2C%20another%20value%2Fexpression%20if%20FALSE)%3C%2FCODE%3E%3C%2FPRE%3E%0A%3CP%3EDepends%20on%20locale%20it%20could%20be%20comma%20or%20semicolon%20as%20separator.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1646979%22%20slang%3D%22en-US%22%3ERe%3A%20IF%20function%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1646979%22%20slang%3D%22en-US%22%3EThats%20exactly%20what%20i%20copied%20and%20it%20doesent%20work.%20I%20tried%20using%20%2C%20.%20%3A%20%3B%20even%20%7C%20before%20%22text%22%20and%20it%20wont%20work%20it%20always%20returns%20error%20in%20function.%20I%20am%20using%20slovenian%20excel.%20I%20even%20tried%20'text'%3C%2FLINGO-BODY%3E
New Contributor
i have been browsing the internet for last 2 hours and couldnt find the answer.
I have a question where i compare numbers wich return results accordingly in true or false wich then is further cunted how many falses are there. If value is greater than 0 it returns false no problem ofcourse. The problem occurs when i want it to type put not ok instead of false. The whole thing collapses i tried on mobile excel and computer nowhere seems for function to work and i litteraly copy pasted the function from support website and it didnt work.
The function in problem is:
IF(D20;D20>0, "NotOk")
I tried also IF(D20>0, "NotOk").
I am very aware how functions work in excel i just cant seem to get it to work to display difirent text than false. And i copy pasted multiple functions from the web.
5 Replies

@Kacion 

That's like

=IF(D20>0, "Perhaps Okey", "Not Ok")

=IF(condition, some value/expression if TRUE, another value/expression if FALSE)

Depends on locale it could be comma or semicolon as separator.

Thats exactly what i copied and it doesent work. I tried using , . : ; even | before "text" and it wont work it always returns error in function. I am using slovenian excel. I even tried 'text'

@Kacion 

Please open attached file, formula is in D18. Formula will be automatically transformed for your locale.

@Sergei Baklan it magicly started to work even on previus functions i tried to make them work. Even at work computer first it didnt work then i tried again after pressing enter a couple of times and suddenly it worked. I dont know why and i very appriciate your help (:

@Kacion , you are welcome. In case on other questions better if you attach sample file, it'll be easier to find what's wrong.