I am using the following formula
=IF(B2=LARGE(B2:B22;1);"A";"B")
The formula works fine if the cells being referenced contain numbers, but if the numbers in those cells are the result of a formula then things don't work.
=IF(B2=LARGE(B2:B22;1);"A";"B")
The formula works fine if the cells being referenced contain numbers, but if the numbers in those cells are the result of a formula then things don't work.