Formula?

Closed
Report
-
Posts
2829
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
November 22, 2021
-
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

Try this...

=IF(AND(A2>A1,B2>B1),"P",IF(AND(A2>A1,B2<B1),"Q", IF(AND(A2<A1,B2>B1),"M","N")))
Posts
2829
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
November 22, 2021
490
Hi Skyeeded,

What do you mean by X = P?