Nesting multiple commands into a formula

[bradleyandrewdavis]

I want to accomplish a few things in one cell. The basics are this:

I want to pull the lowest numbers from a given sample. The sample needs to have a time component (10 lowest out of the most recent 20 results). Those numbers are to be averaged. That average is to be multiplied by .96, then that final yield needs to be truncated to 1 decimal.

Now, I'm not sure this is possible or not. But, if it is, I want to also select the amount of numbers I pull from the sample to average to be based on the sample size itself. For example, if there are 10 results in the sample size, I only want to average the lowest 3 of the 10.

Is it possible to formulate all of these rules into one cell?

[LJMetzger]

Hi,

Read the following referenced post and some of the threads it references and you'll know more than you ever wanted to know about US Golf Handicaps (including the formula you're looking for). http://www.excelforum.com/excel-gene...-software.html

Lewis