If and ifs help

[Jefferson Canedo]

=IF(D2>89,"A",IF(D2>79,"B",IF(D2>69,"C",IF(D2>59,"D","F")))

I’m trying to do this formula but instead of using =IF(D2>89,"A" I’m using =IF(D2>D22,"A"

And when I change the number in the cell With the cell my formula come back with #name?

I close all the parenthesis
Using the latest excel version on my iPad

An if statement with a between in the middle would also help

[#2]

Usually the #Name error indicates there is something wrong with your syntax.  Do you have a non-sensitive copy of your workbook that you could provide or perhaps a few screenshots of the error along with the values.  What does the actual formula look like?

Other Thoughts:

It may be easier to do grades using vlookup rather than an IF statement.  Here's a tutorial to accomplish this: https://exceljet.net/formula/calculate-grades-with-vlookup