Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Logical Functions
I am confused as to why I'm getting a "FALSE" from 3 IF Statements. Here is
my function: =IF(Combo_4_000664!C11="All","1",IF(Combo_4_000664 !C11="quota","0",IF(Combo_4_000664!C11="222","1")) ) but I am getting a "FALSE" when I enter 222 in my linked spreadsheet. I believe it's because I am already using a "1" for my "All" case, so does anyone know how to rewrite this to clean it up. I really appreciate this help, everyone. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Logical Functions
if the 222 you enter is a number, it will not match the "222" text in the
equation try getting rid of the Quote marks in the equation. "Eden397" wrote: I am confused as to why I'm getting a "FALSE" from 3 IF Statements. Here is my function: =IF(Combo_4_000664!C11="All","1",IF(Combo_4_000664 !C11="quota","0",IF(Combo_4_000664!C11="222","1")) ) but I am getting a "FALSE" when I enter 222 in my linked spreadsheet. I believe it's because I am already using a "1" for my "All" case, so does anyone know how to rewrite this to clean it up. I really appreciate this help, everyone. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Logical Functions
Maybe this might be an easier alternative:
=VLOOKUP(Combo_4_000664!C11,{"All",1;"quota",0;"22 2",1},2,0) Above assumes that you want real numbers (ie: 0,1) and not text, as the actual returns -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "Eden397" wrote: I am confused as to why I'm getting a "FALSE" from 3 IF Statements. Here is my function: =IF(Combo_4_000664!C11="All","1",IF(Combo_4_000664 !C11="quota","0",IF(Combo_4_000664!C11="222","1")) ) but I am getting a "FALSE" when I enter 222 in my linked spreadsheet. I believe it's because I am already using a "1" for my "All" case, so does anyone know how to rewrite this to clean it up. I really appreciate this help, everyone. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Logical Functions
=IF(OR(Combo_4_000664!C11={"All","222"}),"1",IF(Co mbo_4_000664!C11="quota","0","else..."))
"Eden397" wrote: I am confused as to why I'm getting a "FALSE" from 3 IF Statements. Here is my function: =IF(Combo_4_000664!C11="All","1",IF(Combo_4_000664 !C11="quota","0",IF(Combo_4_000664!C11="222","1")) ) but I am getting a "FALSE" when I enter 222 in my linked spreadsheet. I believe it's because I am already using a "1" for my "All" case, so does anyone know how to rewrite this to clean it up. I really appreciate this help, everyone. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Logical Functions | Excel Worksheet Functions | |||
logical functions | Excel Worksheet Functions | |||
using logical functions | Excel Worksheet Functions | |||
logical functions | Excel Worksheet Functions | |||
logical functions | Excel Worksheet Functions |