overriding formulas

[Kay]

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

 

[Dave Peterson]

Maybe...

=if(d60="N",0,if($o$3<=20,2,"O3 greater than 20 and d60 <> N")

(I'm not sure what happens in that last portion of the fromula.)

 

[oldchippy]

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

Try this,

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

 

[Gord Dibben]

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