IF Function

%3CLINGO-SUB%20id%3D%22lingo-sub-3186214%22%20slang%3D%22en-US%22%3EIF%20Function%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3186214%22%20slang%3D%22en-US%22%3E%3CP%3EWant%20to%20write%20True%2CFalse%20for%20monthly%20%26gt%3B%2050000.%3C%2FP%3E%3CP%3EHave%20tried%26nbsp%3B%20%3DIF(E3%26gt%3B50000%2CTRUE%2CFALSE)%3C%2FP%3E%3CP%3E%3DIF(E3%26gt%3B%2250000%22%2CTRUE%2CFALSE)%26nbsp%3B%3C%2FP%3E%3CP%3E%3DIF(E3%26gt%3B%2250000%22%2C%22TRUE%2CFALSE%22)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAlways%20give%20the%20answer%200.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3186214%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3186239%22%20slang%3D%22en-US%22%3ERe%3A%20IF%20Function%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3186239%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1311817%22%20target%3D%22_blank%22%3E%40MattA2160%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CPRE%20class%3D%22lia-code-sample%20language-applescript%22%3E%3CCODE%3E%3DIF(E3%26gt%3B50000%2C%22TRUE%22%2C%22FALSE%22)%3C%2FCODE%3E%3C%2FPRE%3E%3CP%3EThis%20works%20in%20my%20sheet.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

Want to write True,False for monthly > 50000.

Have tried  =IF(E3>50000,TRUE,FALSE)

=IF(E3>"50000",TRUE,FALSE) 

=IF(E3>"50000","TRUE,FALSE")

 

Always give the answer 0.

2 Replies

@MattA2160 

=IF(E3>50000,"TRUE","FALSE")

This works in my sheet. 

@MattA2160 

As variant

=E3>50000