combine formula into one

[Carla carla]

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

 

[Kalim Shaikh]

Try This.

=IF(B2=A2,"Expected",IF(B3>A3,"Below",IF(B4>A4,"Above",IF(B5&A5>=6,"Above",IF(B6&A6>=6,"Above",IF(B8<A8,"Below",IF(B7=A7,"Expected")))))))

 

[RoryA]

You already have a thread for this here, so this is now closed. Please do not post the same question more than once.