Previous Topic Next Topic

Formula?

Closed
skyeeded - Dec 29, 2010 at 09:38 AM
TrowaD
Posts
2886
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
June 27, 2022
 - Dec 30, 2010 at 09:56 AM
Hello,

4 conditions:
IF A2>A1 & B2>B1 , then X = P
or IF A2>A1 & B2<B1 , then X = Q
or IF A2<A1 & B2>B1 , then X = M
or IF A2<A1 & B2<B1 , then X = N

how to put in MS Excel formula?

thanks

2 replies

Answer 1 / 2
Sastry
Dec 30, 2010 at 04:30 AM
Try this...

=IF(AND(A2>A1,B2>B1),"P",IF(AND(A2>A1,B2<B1),"Q", IF(AND(A2<A1,B2>B1),"M","N")))
0
Answer 2 / 2
TrowaD
Posts
2886
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
June 27, 2022
 515
Dec 30, 2010 at 09:56 AM
Hi Skyeeded,

What do you mean by X = P?
0