Hi All, I hope I am posting in the correct thread? I am using Microsoft Excel to construct a formula so it is possible to use "IF" statements but I need a little help on the Maths side.

The student has to answer 25 questions while being timed.

The goal is to answer the questions within 25 seconds.

If he answers all questions correctly then this will earn him a rating of 3000 (the maximum rating)

If he answers all questions correctly but takes 50 seconds then his rating would be 1500

If he answers all questions correctly but takes only 15 seconds then his rating would still be 3000.

Can any one help with the Maths relating to this?

Many thanks