Using letters rather than numbers to rate outcomes

[Woody3ER]

Hi ForumL,M,H.xlsx

I am looking to use 3 different categories to rate teams. Low, medium and high. I would like to compare a before and after rating and have an automatic outcome of same, higher or lower. I am not sure how to order the formula to give me all the possibilities, and also leave it blank if the after rating has not yet been entered.

Thanks

[haripopuri]

Look at this one.

[AlKey]

Try this formula in E4 and copy formula down

Please Login or Register  to view this content.

	B	C	D	E
3		Rate Before	Rate After	Comparison
4	Team 1	L	M	Higher
5	Team 2	L	L	Same
6	Team 3	M	L	Lower
7	Team 4	H	M	Lower
8	Team 5
9	Team 6

[martindwilson]

another no table required
'=IFERROR(CHOOSE(SIGN(MOD(CODE(C4),76)-MOD(CODE(D4),76))+2,"HIGHER","SAME","LOWER"),"")

[AlKey]

Thank you for the feedback!