Break Down Excel Formula All the Way to the Math

[DHartwig35805]

ALCON,

Greetings,

Is there a relatively simple way to break down an Excel formula to the math involved? For example, using the PMT formula, you can calculate the monthly payment for a loan, based upon interest rate, present value and length of the loan. That part is easy. What I want to know is the math behind the PMT formula, and for that matter, the math behind any formula. So, that is what prompted my question.

It sounds like "too much detail" for some, but being an old, assembler language programmer, and used to working in ones and zeros, knowing the math is almost prerequisite. However, Excel is so kind to remove the details, and just give you the facts. Well, I'd like the details.

Thanks to any who can help, and I hope to hear from someone, before the end of the year...if not sooner.