Too many nested IF formula (Help required)

[fahadferoz]

Hi Everyone,

I am trying to give a formula in Grade Column (U3).
I know how to use IF formula; however, when I am writing one it says too many Nested IF Formulas have been provided.

Can anybody please help me on this. The number range is also added as a jpeg on the same excel page.

What I am trying to do is to give a formula on U3 cell. The cell will take the grades depending on the numbers on S3 cell.

Any help would be highly appreciated.
Thanks.

 

[pecoflyer]

Try the LOOKUP function syntax #1

 

[fahadferoz]

Can you please do 1 cell for me? Cause I dont understand why would I use Lookup. I have not used that before.

 

[pecoflyer]

If you search the Net you will find many examples of how to do it. Just don't forget to enter the lookup range in ascending order

 

[fahadferoz]

Tried it many times. But could not do it.
If you cant help thats fine.

But i think Vlookup function has nothing to do with it.

 

[GraH - Guido]

But i think Vlookup function has nothing to do with it.

But it does...., Like @pecoflyer suggested.
Please see attached file. (I could only open your file in safe mode)

 

[Deepak Sharma]

Hi Fahadferoz -- Please paste this formula in U3 and drag down.

=IF(S3<60,"F",LOOKUP(S3,{60;67;70;73;77;80;83;87;90;93},{"D";"D+";"C-";"C";"C+";"B-";"B";"B+";"A-";"A"}))

Regards,