Logical IF Function & Google Sheets Confusion

Question

I have to use the logical if function for the following situation.

If a student's exam grade is better than their calculated final grade, use the exam grade as their final mark. I have to use the logical if function that determines the besr grade for the student: either the calculated final grade or their exam grade (a number out of 100).

Exam Grade (Cell P7): 68
Exam Weighting (Cell P5): 35
Exam Total Marks (Cell P6): 85
Calculated Final Grade (Cell Q7): 79

I am so stuck on this and am getting so frustrated with getting the wrong answer.

I know the logical if function follows the format:

=if (expression, value if true, value if false)

And so I entered:

=if(P7/P$6>Q7, P7/P$6, Q7)

What am I doing wrong and where am I going wrong so I know how to do it moving forward?

Thanks so much,

Answer 1

"If ... exam grade is better than ...calculated final grade, use ...exam grade, else use calculated grade"

 if   (         P7              >                          Q7   ,                 P7,                            Q7    )