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

[azores]

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

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

My excel knowledge is obviously rudimentary, and this is as far as
got with the formula before smoke started pouring out of my ears and
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 challengin
problem

 

[azores]

=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")))))

 

[Biff]

Hi!

Try this:

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

Biff