don't go less then 0

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Ivano - 08 Mar 2007 20:25 GMT

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,

Reply to this Message

bj - 08 Mar 2007 20:36 GMT

try
=max(0,IF(B1=0, A2-B2,A3-B3))

> Hi,
> I have a cel that does some calculation and I don't want the value to go
[quoted text clipped - 3 lines]
>
> Thanks,

Reply to this Message

Mike - 08 Mar 2007 20:58 GMT

Try

=IF(B1=0, IF(A2-B2>0,A2-B2,0),IF(A3-B3>0,A3-B3,0))

Mike

> Hi,
> I have a cel that does some calculation and I don't want the value to go
[quoted text clipped - 3 lines]
>
> Thanks,

Reply to this Message