Hi
Im having my IGCSE ICT MOCKS tommorow and my teacher has posted a self made excel paper for us to do.
I have been stuck on the nested IF Function for hours now.
I would really appreciate if someone could show me the formula and tell me a little bit on how to do it as well.

Heres the question:
15) In cell A3, enter a function that works out the reward points using the average. The following criterion is used to work out the points.
a. If the student average is less than or equal to 4 then average multiplied by 2
b. If the student average is between 4 and 7 (inclusive) then average multiplied by 5
c. If the student average is above 7 then average multiplied by 10

Thank You