Logical Functions

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Eden397 - 11 Jun 2007 15:36 GMT

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 to this Message

bj - 11 Jun 2007 15:43 GMT

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.

> I am confused as to why I'm getting a "FALSE" from 3 IF Statements. Here is
> my function:
[quoted text clipped - 6 lines]
> know how to rewrite this to clean it up. I really appreciate this help,
> everyone.

Reply to this Message

Max - 11 Jun 2007 15:53 GMT

Maybe this might be an easier alternative:
=VLOOKUP(Combo_4_000664!C11,{"All",1;"quota",0;"222",1},2,0)

Above assumes that you want real numbers (ie: 0,1) and not text, as the
actual returns

Signature

Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

Reply to this Message

Teethless mama - 11 Jun 2007 16:08 GMT

=IF(OR(Combo_4_000664!C11={"All","222"}),"1",IF(Combo_4_000664!C11="quota","0","else..."))

Reply to this Message