calculate 2 cells,never negative

[Guest]

hello

I want to calculate two cells, and when the outcom is positive then just
show the calculation. On the other hand when the calculation is negative it
must give 0 as a result.
So it's never a <0 figure
What do I use.

Thx in advance

 

[Bob Phillips]

=MAX(0,SUM(A1,B1))


just change the calculation part to whatever you are doing.
--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

 

[Pete_UK]

Don't know what you mean by "calculate two cells", but this will give
you what you want:

=MAX(0,your_calculation)

Hope this helps.

Pete

 

[Guest]

Hello pete/bob

I think i wrote badly what i want
example:



10-5=5
10-9=1
10-10=0
10-12=0

as soon the outcom is <0 it's given a zero

thx for your help

 

[Bob Phillips]

which is what we both gave you.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

 

[Pete_UK]

You are obviously subtracting one cell from another - assume these are
A1 and B1, then the formula becomes:

=MAX(0,A1-B1)

or maybe:

=MAX(0,B1-A1)

Hope this helps.

Pete

 

[Jordon]

Hello pete/bob

I think i wrote badly what i want
example:



10-5=5
10-9=1
10-10=0
10-12=0

as soon the outcom is <0 it's given a zero

=IF(A1-B1<0,0,A1-B1)