overriding formulas
 

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

overriding formulas
 

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

Kay wrote:

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

--

Dave Peterson

overriding formulas
 

Kay;350927 Wrote:
I have the formula if($0$3<=20,2) I want to over ride to equal 0 (zero)
if
cell D60 = N
--
KK

Try this,

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


--
oldchippy
------------------------------------------------------------------------
oldchippy's Profile: http://www.thecodecage.com/forumz/member.php?userid=111
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=98204

overriding formulas
 

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