Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Overriding formula | Excel Worksheet Functions | |||
conditional format overriding border | Excel Discussion (Misc queries) | |||
Overriding zero-strings with previous line constant | Excel Discussion (Misc queries) | |||
Using Invoice template: overriding formulae | Excel Discussion (Misc queries) | |||
MACRO FOR SETTING MARGINS WITHOUT OVERRIDING HEADER AND FOOTER | Excel Discussion (Misc queries) |