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.
Toolsgt;Formula Auditinggt;Evaluate Formula
--
HTH
Bob Phillips
(remove nothere from email address if mailing direct)
quot;Angelaquot; gt; wrote in message
news
gt; If I use the Excel Functions box for a formula such as the financial
formula
gt; PMT is there a way to see how Excel actually uses all the elements of the
gt; formula? I am using Excel 2003.
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
quot;Angelaquot; wrote:
gt; If I use the Excel Functions box for a formula such as the financial formula
gt; PMT is there a way to see how Excel actually uses all the elements of the
gt; formula? I am using Excel 2003.
- Sep 10 Mon 2007 20:39
How do I see the formula calculation used in Excel functions box
close
全站熱搜
留言列表
發表留言