don't go less then 0


G

Guest

Hi,
I have a cel that does some calculation and I don't want the value to go
below zero. The formula in cell A1 is =IF(B1=0, A2-B2,A3-B3) so if either A2
or A3 is less in value then B2 or B3 then the result of the formula is a
negative number. How can I do it so the value will not go below 0?

Thanks,
 
Ad

Advertisements

Ad

Advertisements


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top