How can I use the values from 2 cells in the same row to create a single new value in a new cell?

[Rivermaker]

I have 2 columns (A & B) of paired numbers ranging from 1 - 7. I need to create four categories (1, 2, 3, & 4) from the paired numbers into a third column (C). If A<4 & B<4 then C = 1. If A<4 & B>4 then C = 2. If A>4 & B<4 then C = 3. And if A>4 & B>4 then C = 4.

Is there a formula that can do that for me???

(Newbie)

 

[Fluff]

Hi & welcome to MrExcel.
How about

=IF(A2<4,IF(B2<4,1,2),IF(B2<4,3,4))

 

[kweaver]

Does it look like this?

Book1
	A	B	C
1	7	2	3
2	3	2	1
3	2	4	4
4	3	3	1
5	1	4	4
6	4	2	4
7	1	4	4
8	6	6	4
9	5	2	3
10	2	4	4
Sheet2

Cell Formulas
Range	Formula
C1:C10	C1	=IF(AND(A1<4,B1<4),1,IF(AND(A1<4,B1>4),2,IF(AND(A1>4,B1<3),3,4)))

 

[Rivermaker]

Hi & welcome to MrExcel.
How about

=IF(A2<4,IF(B2<4,1,2),IF(B2<4,3,4))

I don't understand it, but it works! Thank you so much for such a speedy reply! I'm very grateful.

 

[Fluff]

Glad we could help & thanks for the feedback.