Apple Intelligence is now available on iPhone, iPad, and Mac!
When subtracting =A1-A2 I want A3 to be either a positive number, or O if less than positive. Can you give me the basic formula to add onto the =A1-A2 formula to accomplish this task. If possible give the complete formula as it would be written. For example, in layman terms: A3 =A1-A2 (unless A3 is less than 0, then 0). Thanks... I'm a newbie to this so I appreciate your patience.
iMac 21.5″, macOS 11.4
IN A3:
=MAX(A1-A2,0)
Formula in A3 is filled right into the rest of the cells in row 3.
Regards,
Barry
IN A3:
=MAX(A1-A2,0)
Formula in A3 is filled right into the rest of the cells in row 3.
Regards,
Barry
Thanks Barry! It worked like a charm!
I don't use Numbers but on other spreadsheets I would set up and IF formula in the cell where basically IF the results of the calculation was less than zero to enter "0" into the cell.
0 in cell if Negative number
