advanced IF statment

T

tom

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
 
S

Stefi

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:
 
Top