Formula?

Closed

skyeeded - Dec 29, 2010 at 09:38 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 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

Formula?
Logitech formula vibration feedback wheel driver - Download - Drivers
Date formula in excel dd/mm/yyyy - Guide
Number to words in excel formula - Guide
Excel grade formula - Guide
Credit summation formula - Guide

2 responses

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

Answer 2 / 2

TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 552
Dec 30, 2010 at 09:56 AM

Hi Skyeeded,

What do you mean by X = P?

Similar discussions

How to calculate positions (1st,2nd,3rd...) in Excel

How to calculate position (1st,2nd,3rd) in excel....?

Calculation of positions in excel

formulas for 1st and 2nd position in class

Similar discussions

Subscribe To Our Newsletter!