Thread: Formula
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
BSantos
 
Posts: n/a
Default Formula

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