HOW CAN I MAKE A FORMULA RETURN A ZERO

[Guest]

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 Harkawat]

the place where you get a negative enter the following

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

 

[Guest]

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)

 

[Naraine]

utilize the if function...

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