Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IF formula question
My question is, I want to add "if" E2 is blank leave R2 blank in
addition to formula below. This Formula is in R2 cell. =IF(P2<1,"A",IF(P21,"B",IF(P2<2,"G"))) Thanks, Rube |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IF formula question
"Rubix" wrote...
My question is, I want to add "if" E2 is blank leave R2 blank in addition to formula below. This Formula is in R2 cell. =IF(P2<1,"A",IF(P21,"B",IF(P2<2,"G"))) E2? Do you mean P2? The formula above would only return "G" when P2=1. If that's what you want, it'd be LOTS clearer to write it as =IF(P2<1,"A",IF(P21,"B","G")) Since P2<1, P21 and P2=1 are exhaustive, the only place you could add another condition would be as the first test. =IF(ISBLANK(E2),"",IF(P2<1,"A",IF(P21,"B","G"))) |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IF formula question
"Rubix" wrote:
My question is, I want to add "if" E2 is blank leave R2 blank in addition to formula below. This Formula is in R2 cell. =IF(P2<1,"A",IF(P21,"B",IF(P2<2,"G"))) It is not clear which conditions you want to give precedence to; that is, which conditions override the others. The following are two possibilities: 1. "E2 is blank" overrides all other conditions =IF(E2="","",IF(P2<1,"A",IF(P21,"B",IF(P2<2,"G")) )) 2. All other conditions override "E2 is blank" =IF(P2<1,"A",IF(P21,"B",IF(P2<2,"G",IF(E2="","")) )) Note: I have omitted the false-value part of the last IF() function, just as you did. In some contexts in Excel, that is the right thing to do. But normally, I think it is best to have a false-value part |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IF formula question
Thanks!
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Match then lookup | Excel Worksheet Functions | |||
Formula Question | Excel Worksheet Functions | |||
I have a question regarding countif formula. | Excel Worksheet Functions | |||
formula (IF) question | Excel Worksheet Functions | |||
Formula Question | Excel Discussion (Misc queries) |