Thread
:
Nested IF
View Single Post
#
2
Posted to microsoft.public.excel.worksheet.functions
Don Guillett
external usenet poster
Posts: 10,124
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??
Reply With Quote
Don Guillett
View Public Profile
Find all posts by Don Guillett