Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Nested Function
Hi, I am trying complete a project where I need to use nested functions. The
scenario is I have 4 amounts that are grades. The lowest grade is dropped, and the remaining 3 are averaged to give the grade. I have to use the SUM, MIN and COUNT function within the same cell address to get the answer. Here is where I'm stuck... =SUM(B4:E4)-MIN(B4:E4) I'm not sure how to use the COUNT function to give me a 3 since all 4 cells will have amounts? Plus how will I get the above to give me an average? ANy help appreciated so I can sleep. :-) |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Nested IF function | Excel Worksheet Functions | |||
Custom functions calculating time arguments Help Desperate | Excel Worksheet Functions | |||
Nested "If" Function | Excel Worksheet Functions | |||
Automatically up date time in a cell | Excel Discussion (Misc queries) | |||
Countif Function -Nested | Excel Discussion (Misc queries) |