EmPhillips
New Member
I need an excel formula that subtracts cell A3 from A2 and but if the number is less than 0 it stills gives me the value of 0 and not a negative number....Help!
IF/THEN question
- Thread starter EmPhillips
- Start date
John Jairo V
Well-Known Member
Hi @EmPhillips.
Try this formula:
=MAX(0,A2-A3)
But, if you want with IF function:
=IF(A2-A3<0,0,A2-A3)
Blessings!
Try this formula:
=MAX(0,A2-A3)
But, if you want with IF function:
=IF(A2-A3<0,0,A2-A3)
Blessings!
EmPhillips
New Member
Thank you John that was exactly what I needed. I was missing one of the comma's and just couldn't see it for the weeds!!!