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.