![]() |
How do I see the formula calculation used in Excel functions box
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. |
How do I see the formula calculation used in Excel functions box
ToolsFormula AuditingEvaluate Formula
-- HTH Bob Phillips (remove nothere from email address if mailing direct) "Angela" wrote in message ... 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. |
How do I see the formula calculation used in Excel functions box
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 "Angela" wrote: 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. |
All times are GMT +1. The time now is 04:27 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com