How do I see the formula calculation used in Excel functions box

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

If I use the Excel Functions box for a formula such as the financial formula
PMT is there a way to see how Excel actually uses all the elements of the
formula? I am using Excel 2003.
 
Tools>Formula Auditing>Evaluate Formula

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)
 
Your question is ambiguous. If Bob's answer is not what you were seeking,
then see Help for the PV worksheet function, which gives the mathematical
relationship among the various arguments for the financial functions.

Jerry
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

IF AND Nested Functions - Formula Not Working 0
Advanvnce formula and function 1
pmt() uses 360-Days Bases, I need 365-Days Bases 1
Scrabble Value calculation for Welsh words 0
Display formula Excel uses for internal functions (STDEV...) 1
Help to create amortization schedule 0
Excel Functions 2
PPMT function replacement 1

Back
Top