IF function with multiple results: No problem for you guys, but for me...
 

Hi:
I deal primarily with the left side of my brain, so this problem is
giving me a migraine. But I've no doubt it's a piece of cake to you
wise lot, so I'll just ask:

I'm trying to construct an excel formula that looks at cell C2 and, if
the value in that cell is 0, the formula spits out "0"; if the value is
1, the formula spits out "-2"; if the value is 2, the formula spits out
"-4"; if the value is 3, the formula spits out "-5", and if the formula
is equal to or greater than 4, the forula spits out the text
"Deactivate".

My excel knowledge is obviously rudimentary, and this is as far as I
got with the formula before smoke started pouring out of my ears and I
crawled into a fetal position on the floor:

=IF(C2=0,"0",IF(C2=1,"-2"))

Appreciate any help- sorry for not submitting a more challenging
problem!


--
azores
------------------------------------------------------------------------
azores's Profile: http://www.excelforum.com/member.php...o&userid=29246
View this thread: http://www.excelforum.com/showthread...hreadid=489706

IF function with multiple results: No problem for you guys, but for me...
 

=IF(AND(C2=0),"0",IF(AND(C2=1),"-2",IF(AND(C2=2),"-4",IF(AND(C2=3),"-5",IF(AND(C2=4),"Deactivate")))))


--
azores
------------------------------------------------------------------------
azores's Profile: http://www.excelforum.com/member.php...o&userid=29246
View this thread: http://www.excelforum.com/showthread...hreadid=489706

IF function with multiple results: No problem for you guys, but for me...
 

Hi!

Try this:

=IF(C2<3,C2*-2,IF(C2=3,-5,"Deactivate"))

Biff

"azores" wrote in
message ...

=IF(AND(C2=0),"0",IF(AND(C2=1),"-2",IF(AND(C2=2),"-4",IF(AND(C2=3),"-5",IF(AND(C2=4),"Deactivate")))))


--
azores
------------------------------------------------------------------------
azores's Profile:
http://www.excelforum.com/member.php...o&userid=29246
View this thread: http://www.excelforum.com/showthread...hreadid=489706