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
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.
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.
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
Barry I cannot thank you enough, you absolute life saver! It's worked a treat, I'm still a bit perplexed about how this works but moreover just very grateful to yourself for solving this request!
Boolean in Place of Number Error In my Formula
