Question
July 30, 2008 at 06:42 AM
tedmills

Problem with nested functions.

by tedmills . Updated 17 years, 11 months ago

I have a simple spreadsheet which uses the AVERAGE function to find the sum of the 10 largest numbers in a named range of 50+ numbers. This works fine as it stands. I wish to use this in an IF function to give me a value of 0 if there are less than 10 entries in the named range. My IF statement reads =IF (counter)LT 10,0,=AVERAGE…..

This fails every time.

I am sure that I can use nested functions in this way but am getting very frustrated.

Can anybody help me please?

This discussion is locked

All Comments