HOW CAN I MAKE A FORMULA RETURN A ZERO

J

Jim Lowe

I am working with an inventory analysis spread sheet and want to calculate
projected orders and need to change negative calculations to zero so that I
can get a total number of all items required.
 
N

N Harkawat

the place where you get a negative enter the following

=min(0,your formula that makes the value zero)
 
B

bigwheel

Jim Lowe said:
I am working with an inventory analysis spread sheet and want to calculate
projected orders and need to change negative calculations to zero so that I
can get a total number of all items required.
Click to expand...
Check for a negative value and replace with 0 if true
=IF(A1<0,0,A1)
 
Top