Trying to compare two columns with text and number

[Davebro]

Is it possible to compare the numbers in text and say if column A is Up or down from column B.
(Class 1 is better than class 2).

Book2
	A	B	C
1	Class 6	Class 6
2	Class 6	Class 6
3	Class 3	Class 4	Up
4	Class 4	Class 4
5	Class 5	Class 6	Up
6	Class 5	Class 5
7	Class 4	Class 3	Down
8	Class 4	Class 4
9	Class 4	Class 4
10	Class 6	Class 5	Down
11	Class 4	Class 4
12	Class 6	Class 6
Sheet1

 

[Fluff]

How about

=LET(a,RIGHT(A1,2),b,RIGHT(B1,2),IF(a=b,"",IF(a>b,"down","up")))

 

[Cubist]

Try:

=IF(A1=B1,"",IF(A1<B1,"Up","Down"))

 

[Davebro]

=LET(a,RIGHT(A1,2),b,RIGHT(B1,2),IF(a=b,"",IF(a>b,"down","up")))

Terrific, thanks again for your help.

 

[Fluff]

Glad we could help & thanks for the feedback.

 

[Davebro]

Try:

=IF(A1=B1,"",IF(A1<B1,"Up","Down"))

Many thanks, that works fine.