You can make a difference in the Apple Support Community!

When you sign up with your Apple Account, you can provide valuable feedback to other community members by upvoting helpful replies and User Tips.

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

Boolean in Place of Number Error In my Formula

The ERROR: "The formula uses a Boolean in place of a number"


If the results of said formula return 0 or a negative number then a blue check mark appears. I need to get this formula to work without a blue check mark appearing the number is 0 or below. The blue checkmark disappears when the results is over 0.


MacBook Pro Apple Silicon

Posted on Oct 16, 2022 8:04 AM

Reply
Question marked as Top-ranking reply

Posted on Oct 16, 2022 12:10 PM

Try this: IF(C1>11909,(C1-11909)*0.0125,"loss")


Replace the text "Loss" with the calculation you want to occur inthe case of C1 being less than 11909.


Regards,

Barry


UPDATE: Formula edited to remove excess parenthesis.

3 replies

Oct 16, 2022 2:10 PM in response to MattAllsop

Hi Matt,


You're welcome.

I was in a bit of a rush when posting the replay above (hence the update to correct the formula not long after posting).


You can learn more about IF (and about any other function supported in Numbers formulas) in the Function Browser.

The browser opens in the right sidebar of the screen image whenever you select a cell and press = to indicate you are entering a formula.

You can view the browser entry for any function by typing the first few letters of the function's name, then clicking the name when it appears in the list of functions fitting what you've typed.


And, of course, you are always welcome to post further questions here when you run into future perplexing situations.


Regards,

Barry

Boolean in Place of Number Error In my Formula

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