Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IF and Lookup
I need to find a way to calculate the performance of a student doing a curl
up challenge based upon the number of curl ups they do and the age of the student. Because the pass/fail rate changes with age, I think I need to use another worksheet to reference the standards. For example age 8 needs 18 curl ups and age 10 needs 20. And Girls is another story. I want to do a IF statement that will state a pass or fail, but the varying age of students in a class cause a problem. Can I lookup a table using Age to reference a age related standard to determine the IF statement that will show if the student passes or fails. Any help would be great. I would give more excel related information, but I am not sure how to do this. Example Marc D age 8 does 18 curl ups which equals the 8 year old standard of 18 but David age 10 does 1 curl ups which does not meet the 10 year old standard of 22. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Matrix lookup/mulitple criteria lookup | Excel Discussion (Misc queries) | |||
Get Cell Address From Lookup (Alternative to Lookup) | Excel Worksheet Functions | |||
Join 2 Lists - Lookup value in 1 list & use result in 2nd lookup | Excel Worksheet Functions | |||
Sumproduct - Condition based on lookup of a Lookup | Excel Discussion (Misc queries) | |||
Pivot table doing a lookup without using the lookup function? | Excel Discussion (Misc queries) |