Hi Tom,

If I understood well your question, this formula answers it:

Assuming the criteria is A1=10

=IF(A1=10,1+INT((A1/10-1)/0.05),0)

If I misunderstood your question, please give an example!

Regards,
Stefi

€žtom€� ezt Ã*rta:

Hello,

i was wondering if anyone could tell me how to create an IF statement where
i want to compare a a set criteria to a result and give it 1 mark it it makes
the criteria and then and extra 1 point for ever 5% it is above the criteria

thankyou