advanced IF statment

  • Thread starter Thread starter qwertyqwerty
  • Start date Start date
Q

qwertyqwerty

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

thanks
 
Hi

With your Mark in A1 and your Criteria in B1, try
=--(A1>B1)+INT(((A1-B1)/B1)/0.05)

Regards

Roger Govier
 

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

advanced IF statment 1
Excel Need Countifs Formula Help 0
Access Dcount (multiple criteria) 3
if statements 3
How to finding student Rank and How to upload bulk marks of each student at a time. 1
IF Statements 0
Error: Compile Error,ByRef argument type mismatch 0
Checking for how many occurances, given two different criteria 1

Back
Top