I think your original formula should have another argument or it will show
FALSE if O3 is 20.

If that's OK then ignore the "greater than 20" argument.

=IF($O$3<=20,2,"greater than 20")

Combining with D60 value.

=IF(D60="N",0,IF($O$3<=20,2,"greater than 20"))


Gord Dibben MS Excel MVP


On Tue, 19 May 2009 14:01:01 -0700, Kay
wrote:

I have the formula if($0$3<=20,2) I want to over ride to equal 0 (zero) if
cell D60 = N