need HELP on a formula

  • Thread starter Thread starter Brian
  • Start date Start date
B

Brian

I am subtracting one cell from another, but i don't want
it answer to go into the negatives. If the answer is
negative, i want it to be zero. any help out there for
me?
 
Just a thought, but could you use the If statement, for
example--

If (a1-a2>0, a1-a2, 0)

This should give you the difference between a1 and a2 if
the difference is greater than zero. Otherwise, it should
return a zero.

Hope this helps,

-Dan.
 
Back
Top