rating using if

[steve hill]

Hi having a blonde day cant work out an if formula
I want to a letter in a sell based on a score
A above 91
B between 81 and 90
C below 80

thanks
steve

 

[Michael M]

try

=IF(A1<80,"C",IF(A1<=91,"B","A"))

 

[anandvarma]

try this

Excel Workbook
	A	B
1	81	B
Sheet1

 

[Weaver]

or

=LOOKUP(A2,{0,80,90},{"C","B","A"})