close

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.

全站熱搜
創作者介紹
創作者 software 的頭像
software

software

software 發表在 痞客邦 留言(0) 人氣()