if statement

[rizexcel]

=IF(H21>84,"A",IF(H21>79,"A-",IF(H21>74,"B+",IF(H21>69,"B",IF(H21>64,"B-",IF(H21>59,"C+",IF(H21>54,"C",IF(H21>49,"C-","F"))))))))

above formula accepts 8 conditions. If more than 8 require then what will be the solution. Please help.

 

[VoG]

Try like this

=LOOKUP(H21,{0,49,54,59,64,69,74,79,84},{"F","C-","C","C+","B-","B","B+","A-","A"})

 

[Aladin Akyurek]

=IF(H21>84,"A",IF(H21>79,"A-",IF(H21>74,"B+",IF(H21>69,"B",IF(H21>64,"B-",IF(H21>59,"C+",IF(H21>54,"C",IF(H21>49,"C-","F"))))))))

above formula accepts 8 conditions. If more than 8 require then what will be the solution. Please help.

Something like:

=LOOKUP(H21,{0;49;54;59;64;69;74;79;84},{"F";"C-";"C";"C+";"B-";"B";"B+";"A-";"A"})

 

[rizexcel]

Thank you very much.

 

[kevatarvind]

=lookup(h21,{0,50,55,60,65,70,75,80,85},{"f","c-","c","c+","b-","b","b+","a-","a"})