K
Kay
I have the formula if($0$3<=20,2) I want to over ride to equal 0 (zero) if
cell D60 = N
cell D60 = N
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
D
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.)
=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.)
O
oldchippy
Kay;350927 said: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,""))
G
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
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