ExcelBanter - advanced IF statment

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - advanced IF statment (https://www.excelbanter.com/excel-discussion-misc-queries/56105-advanced-if-statment.html)

tom

advanced IF statment

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

Stefi

advanced IF statment

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

All times are GMT +1. The time now is 02:21 PM.