Formula Question

[Jana]

Version: 2008 Operating System: Mac OS X 10.6 (Snow Leopard) Processor: Intel I am trying to create a formula that if

E6 - E8 is less then 0 I want the value of the cell to be zero. Does anyone know how I can do this?

Thanks.

 

[CyberTaz]

One option: In the cell where you want the result enter the formula;

=If(e6-e8<0,0,e6-e8)

HTH |:>)
Bob Jones
[MVP] Office:Mac

 

[Dave Peterson]

=if(e6-e8<0,0,e6-e8)
or
=if(e6<e8,0,e6-e8)
or even shorter:
=max(e6-e8,0)

 

[Jana]

Thank you very much!