Looks like no one’s replied in a while. To start the conversation again, simply ask a new question.

The "IF" function will not work

Hey Everyone,


I'm having trouble using the "IF" function. I would like to check wether a certain field has a number greater than 0 in it. If that is true it outputs the text "True", if it's not the case it outputs the text "False".


I've tried everything so far and I just can't get this simple function to work. Even when I use the following function, it gives me a syntax error:


IF(3 > 1, “True”, “False”)


Any ideas what i'm doing wrong? I've tried changing the field type from number to text and automatic. Also that was not successful.


Thanks in advance,

Jordy

MacBook Air (13-inch Mid 2012), OS X Yosemite (10.10.5), Numbers V3.5.3

Posted on Oct 7, 2015 1:55 AM

Reply
Question marked as Best reply

Posted on Oct 7, 2015 2:59 AM

Hi Jordy,


User uploaded file

Formula in B2 (and Fill Down)

=IF(A2>0,"True","False")


Does your Region use comma (,) as the decimal separator? If so, use semicolon (;) as the formula separator

=IF(A2>0;"True";"False")


Regards,

Ian.

3 replies

Oct 7, 2015 3:19 AM in response to jordyvandeput

Hi Jordy,


Thanks for the green tick. The email notification arrived before your reply (the forum software is playing up).

It's weird that the help pages show commas but the program works on semicolons.

Try Formulas & Functions Help

http://help.apple.com/functions/mac/5.0/

Click on Change Language

User uploaded file

Perhaps that will show semicolons for your region?


Regards,

Ian.

The "IF" function will not work

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple ID.