Formula Question

J

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.
 
C

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
 
D

Dave Peterson

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