Is this Excel formula possible?

[fenderbass86]

Hi

My girlfriend needs help with a grading system that scales base marks, depending on difficulty. I have provided a link for the grading system in place:

Page 22:

https://qualifications.pearson.com/...ication/Specification_GCSE_L1-L2_in_Music.pdf

So you can see that a raw mark of 10 becomes 13 on standard difficulty but 15 when the piece is more difficult.

Is there a formula (I was thinking an IF statement?) where changing the raw mark would automatically calculate the scaled mark?

Thanks if anyone can help.

 

[fenderbass86]

Thanks very much for this mate. Will take a while to get it to work how I want it.