Formula
You can use the MAX function make it only give you 0 and higher as
follows:
=MAX ( ##, 0)
thus:
=MAX(IF(AND(G6=0,O6=0),P6,IF(G6=0,O6,G6-N6)),0)
BSantos wrote:
=IF(AND(G6=0,O6=0),P6,IF(G6=0,O6,G6-N6))
The above formula is in cell Q6 the results is a negative number. example
-2. I want to add to this formula above that if the results is less than Zero
than give me Zero.
Any help!
B.
|