I am trying to change the text of a cell in Numbers 3 according to a condition.
E.g. if A1-A2 is a negative value, the text shall be 'Negative'. If the value is positive the text shall be 'Positive'. Is there something like a function to accomplish this?
Numbers: How to change cell text conditionally
iworknumbers
Related Question
- MacOS – The SUM function in Numbers 3.6.1 on the Mac OS X10.10.5 isn’t calculating correctly. Why
- Getting the First Cell NOT Containing Certain Text in Numbers
- Text substitution and change cell background colour. Numbers & AppleScript
- Setting the value of a Numbers cell using AppleScript
- MacOS – iWork Numbers How To Calculate – In Once Cell Function – The Elapsed Time In Hours Between Two Date/Times
- Range of values for a cell in Numbers
Best Answer
You can do this with the IF function. The syntax is…
This results in the following calculation:
Result:
An example for comparing a calculation in the
if-expression
:Result:
However, this will return
Positive
even if the number is0
, so instead…