No value less than 0

[Steven]

How can I constrain a simple A-B calculation to not
display negative numbers? I am trying to gauge customer
resupply levels but the negative numbers are messing up
the totals. Thanks.

 

[Harald Staff]

=(A1-B1)*(A1>B1)
=MAX(A1-B1,0)
=IF(A1>B1,A1-B1,0)

Note that these will actually return zero , not just contain negative values
and display zero. Hope that's what you want.

 

[Anon]

How can I constrain a simple A-B calculation to not
display negative numbers? I am trying to gauge customer
resupply levels but the negative numbers are messing up
the totals. Thanks.

Instead of
=A1-B1
you could use
=MAX(A1-B1,0)
Any negative difference would then result in 0 instead.
Is this what you need?

 

[barb]

-----Original Message-----
How can I constrain a simple A-B calculation to not
display negative numbers? I am trying to gauge customer
resupply levels but the negative numbers are messing up
the totals. Thanks.
.

type: =if(sum(A-B)<0,0,(A-B))

 

[Steven]

Thanks! That fixed it.

-----Original Message-----
Steven, will this work? =IF(A1-B1<0,0,A1-B1)

--
Paul B
Always backup your data before trying something new
Using Excel 2000 & 97
Please post any response to the newsgroups so others can benefit from it
** remove news from my email address to reply by email **



.

 

[Ledu]

Using your example
=IF(A-B<0,0,A-B)
Should be
=IF(A1-B1<0,0,A1-B1)
This will enter a 0 for any negative number into the column