HOW CAN I MAKE A FORMULA RETURN A ZERO
 

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.

the place where you get a negative enter the following

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

"Jim Lowe" <Jim wrote in message
...
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.

"Jim Lowe" wrote:

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.


Check for a negative value and replace with 0 if true
=IF(A1<0,0,A1)

utilize the if function...

if("your calculation <0,0,your calculation)

"Jim Lowe" <Jim wrote in message
...
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.