Description
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
Unformatted Attachment Preview
Purchase answer to see full attachment
Explanation & Answer
HelloPFA the solution. Please add your name as studentName or please let me kno...