formula help

[david graham]

Is there a way to make the result of the formula below = 0 if the result is a neg number?

So, if the result was -1, it would show a 0.


=(I3578*IF!$Z$449)-L3602

 

[Fazza]

Hi, David. Maybe? Fazza

=max(0,(I3578*IF!$Z$449)-L3602)

 

[c_m]

deleted

 

[david graham]

thanks, knew that was an easy one