General discussion
May 8, 2005 at 07:54 PM
atrav

The ‘real’ math behind Excel formulas

by atrav . Updated 21 years, 3 months ago

Is there a way, within Excel or somewhere, to find the true mathematical calculation or equation that Excel is using when the formula is entered with a function word?

For example, if I use the function formula word =AVERAGE(A1:A5), I would like to find the ‘real’ equation like =(A1+A2+A3+A4+A5)/5

What I’m especially interested is in the actual mathematical formula for the =PMT and =FORECAST function words.

This discussion is locked

All Comments