I'm getting sick so I'm stupid right now. help with excel, please?
Posted by
amanda
Sep 17 '12, 13:03
|
if column B is UP006 or if it's UP260 *and* column C is FT>12, I want to perform a function.
how do I do nested if with multiple thingies?
(yeah, I'm getting sick. parameters?)
thanks.
|
Responses:
-
just to keep this all to one thread, I would like to remind everyone that uses excel that "," and "*" are very different.
-
amanda
Sep 17, 13:33
1
-
Just email the worksheet to znu ... have a coffee .. and it'll be in your email when you return -- nm
-
budice
Sep 17, 13:18
-
=IF(OR(B1=UP006, AND(B1=UP260, C>12)),1, 0) -- nm
-
znufrii
Sep 17, 13:05
8
-
After trial and error, I found that =IF(OR(B1="up006",AND((B1="up260"),(C1>12))), 1,0) works
-
JD
Sep 17, 13:54
-
wait, this doesn't work. it can't be both. -- nm
-
amanda
Sep 17, 13:09
3
-
Its amazing how well some of you know Excel -- nm
-
Jovian
Sep 17, 13:07
-
I make out with you. (but not really because I'm getting sick.) thanks, znu. -- nm
-
amanda
Sep 17, 13:05
1
|