A simple formula in Excel 2003 please

Hi Chris,

Try this formula, =average(a1:g1) This will give you a simple average. For the complete list of formulas (more than you'll ever use), in Excel click on the smart button (at the top of the screen) with the symbol, fx

I hope this helps, Russell Tuncap, CMA, CPA

This depends more on the definition you wish for "average", but straightforward, how about

average(a1:g1)

??

An extremely easy way to get this answer is to highlight (by dragging the mouse over A1 to G1) and looking at the bottom right of the Excel spreadsheet. There you will see either the Sum of those items or some other item. By right clicking on that area with your mouse, you can get a number of answers from your highlighted list including: average, count, count nums, max, min, and sum. I hope this helps.

Wayne Brasch

Thank you Russell, Duane and Wayne, you cannot know how grateful I am. An such a simple answer has made me check out even more stuff and gain a knowledge of it all. Regards Chris.

And, btw, the general expression for average compound rate if you have start and end values is v2/v1 = (1 + x)^n. To solve for x, take logs of both sides and then inverse log. Using natural logs, and recalling that "exp(ln(anything)) = anything",

ln(v2/v1) = n * ln(1 + x) ==> ln(1 + x) = (1/n) * ln(v2/v1)

exp(ln(1 + x)) = 1 + x = exp[(1/n) * ln(v2/v1)]

or

x = exp[(1/n) * ln(v2/v1)] - 1