| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Nested IF
I can't figure out a formula for the following problem:
Student A has the choice of taking 4 out of 5 possible test but if he took all 5 then the lowest grade would be dropped?? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Nested IF
Assuming grades are in d18,d19,d20,d21,d22 then put this in e18 and copy
down FOUR =IF(LEN(TRIM(D18))<1,"",LARGE($D$18:$D$22,ROW(A1)) ) -- Don Guillett Microsoft MVP Excel SalesAid Software "Tony" wrote in message ... I can't figure out a formula for the following problem: Student A has the choice of taking 4 out of 5 possible test but if he took all 5 then the lowest grade would be dropped?? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Nested IF
Tony,
=(SUM(B2:B6)-IF(COUNT(B2:B6)=5,MIN(B2:B6),0))/MIN(COUNT(B2:B6),4) with test grades in B2:B6 HTH, Bernie MS Excel MVP "Tony" wrote in message ... I can't figure out a formula for the following problem: Student A has the choice of taking 4 out of 5 possible test but if he took all 5 then the lowest grade would be dropped?? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Nested if | Excel Discussion (Misc queries) | |||
| Nested IF with a possible SUM? | Excel Discussion (Misc queries) | |||
| Nested if help.... | Excel Worksheet Functions | |||
| nested if based on nested if in seperate sheet. how? | Excel Worksheet Functions | |||
| nested if | Excel Worksheet Functions | |||
Linear Mode
