Simple "if" question

Hello,

I am not very well versed in Excel and I need help with what appears to be a simple problem.

I am trying to create a spreadsheet that calculates a grade. I have one column where the total score appears. In the next column I want the letter grade to appear based on the score. This is not for students but for my other projects. If the score is less than 8, the project gets a D, if the score is less than 16, the project gets a C, if the Project is less than 22 the project gets a B, and if the project is equal to or greater than 22 The project gets an A.

I was able to accomplish this for the grades D and C with this: =IF(W3<8,"D","IF(W3<16,WC")

However, when I add any more "if" statements to the formula I get an error message.

What how can I add the other two grades?

Thank you!

Awesome! Thank you! That worked.

Now that I have my grade assigned to each project. Do you know if there is a means for me send all of the names of projects with certain grades to different sheets within the same workbook? For example, if the the project names are in column "a" and the grades are in column "w" can I send all of the names of projects with grade of an "A" to one column on sheet #2 and all project names with a "B" to the second column on sheet #2 and so fourth?

Thanks again!

Awesome! Thank you! That worked.

Now that I have my grade assigned to each project. Do you know if there is a means for me send all of the names of projects with certain grades to different sheets within the same workbook? For example, if the the project names are in column "a" and the grades are in column "w" can I send all of the names of projects with grade of an "A" to one column on sheet #2 and all project names with a "B" to the second column on sheet #2 and so fourth?

Thanks again!