Forum Discussion
If and ifs help
=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
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
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
