| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Advanced Filters | Excel Worksheet Functions | |||
| advanced filter criteria "begins with" and "does not begin with" | Excel Worksheet Functions | |||
| Using advanced filter to search for criteria in a list | Excel Discussion (Misc queries) | |||
| Advanced Find Command?? | Excel Discussion (Misc queries) | |||
| Can Excel advanced filter be used in "and NOT" mode | Excel Worksheet Functions | |||
Linear Mode
