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.
When you sign up with your Apple Account, you can provide valuable feedback to other community members by upvoting helpful replies and User Tips.
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
