assigning descriptors in excel

[Carla carla]

mark 1	mark 2	descriptor ( compares mark 1 and mark 2)
5	5	expected
6	6	above
6	7	above
5	8	above
5	4	below
4	3	below
4	4	expected

Basically, if mark 1 and 2 are 6 and above i want it the descriptor to be above. then if mark 1 and mark 2 are the same from 1to 5 i want it to return as expected. lastly if mark 2 is lower than mark 1 ( marks 1-5) i want it to return as below.

 

[Michael M]

Maybe this

=IF(AND(A2>5,B2>5),"Above",IF(AND(A2<5,B2<5),"Below","Expected"))

But you logic doesnt agree with the results in the table. The last line shows 2 4's, so should it not be "Below"
and line 4 shows 5 and 8, so shouldn't that be "expected"

 

[Carla carla]

Maybe this

=IF(AND(A2>5,B2>5),"Above",IF(AND(A2<5,B2<5),"Below","Expected"))

But you logic doesnt agree with the results in the table. The last line shows 2 4's, so should it not be "Below"
and line 4 shows 5 and 8, so shouldn't that be "expected"

I want the logic to be
If mark is =>6 for both marking period descriptor should be Above
If mark 2 is higher than mark 1 it should be above

if mark 1 and mark 2 is the same within the range of 1-5 it should be expected

if mark 2 is lower than mark 1 within the range of 1-3 it should be lower

 

[Carla carla]

mark 1	mark 2	descriptor ( compares mark 1 and mark 2)
5	5	Expected Maybe this =IF(AND(A2>5,B2>5),"Above",IF(AND(A2<5,B2<5),"Below","Expected")) But you logic doesnt agree with the results in the table. The last line shows 2 4's, so should it not be "Below" and line 4 shows 5 and 8, so shouldn't that be "expected"
6	7	Below
5	8	Above
6	6	Above
7	8	Above
4	4	Expected
4	3	Below

This is what I am expecting, how can I combine in one formula?

mark 1	mark 2	descriptor ( compares mark 1 and mark 2)
5	5	=IF(B2=A2,"Expected")
6	7	=IF(B3>A3,"Below")
5	8	=IF(B4>A4,"Above")
6	6	=IF(B5&A5>=6,"Above")
7	8	=IF(B6&A6>=6,"Above")
4	4	=IF(B7=A7,"Expected")
4	3	=IF(B8<A8,"Below")

 

[Carla carla]

Maybe this

=IF(AND(A2>5,B2>5),"Above",IF(AND(A2<5,B2<5),"Below","Expected"))

But you logic doesnt agree with the results in the table. The last line shows 2 4's, so should it not be "Below"
and line 4 shows 5 and 8, so shouldn't that be "expected"