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