advanced IF statment

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

if statements 3
advanced IF statment 2
Excel Need Countifs Formula Help 0
Access Dcount (multiple criteria) 3
If Statments 2
How to finding student Rank and How to upload bulk marks of each student at a time. 1
How pull ID#s that meet specific "yes" requirements 3
IF statement formular 7

Back
Top