excel practical exercise 6 if and nested if statements

I don’t know how to find the formula if and nested if statements.

In struggling with this

1.Use an IF Function to create the Grade Values.Use the NOTE:Grade Values to help you. You will need to use a NESTED IF statement.

Condition:IF Current Grade = “A”, then 4.0, else IF Current Grade = “B”, then 3.0, else IF Current Grade = “C”, then 2.0, else IF Current Grade = “D”, then 1.0, else IF

Current Grade = “F”, then 0.0, else 0.0

"Looking for a Similar Assignment? Order now and Get a Discount!

Place New Order
It's Free, Fast & Safe

"Looking for a Similar Assignment? Order now and Get a Discount!

"Looking for a Similar Assignment? Order now and Get a Discount!

Get better grades effortlessly,
It’s cheaper than you might think

Effortlessly get the essays and grades you need. You can now get any essay, on any subject and at ANY deadline with just 10 minutes of your time (or less). Your professor will love you for it!