Formula?

Question

Formula?

Closed

Report

skyeeded - Dec 29, 2010 at 09:38 AM
TrowaD

Posts: 2829
Registration date: Sunday September 12, 2010
Status: Moderator
Last seen: November 22, 2021

- 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?
Spreadsheet formula - Articles
Excel @ in formula ✓ - Forum - Excel
1st, 2nd, 3rd position formula in excel ✓ - Forum - Office Software
How to copy data from one sheet to another in excel using formula - How-To - Excel
Excel formula if cell contains text then return value in another cell ✓ - Forum - Excel

2 replies

Ask a question

Sastry · Answer 1 · 2010-12-30T04:30:39-0500

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

TrowaD · Answer 2 · 2010-12-30T09:56:25-0500

Answer 2 / 2

TrowaD

Posts: 2829
Registration date: Sunday September 12, 2010
Status: Moderator
Last seen: November 22, 2021

490
Dec 30, 2010 at 09:56 AM

Hi Skyeeded,

What do you mean by X = P?

Formula?

2 replies

Your reply

Subscribe To Our Newsletter!