| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to use built-in Excel functions in PivotTable formula? | Excel Worksheet Functions | |||
| excel formula calculation turned off?? | Excel Discussion (Misc queries) | |||
| Mathematical explanations/equations for Excel functions in "Help" | Excel Worksheet Functions | |||
| Excel Calculation Error for formula to sum | Excel Discussion (Misc queries) | |||
| EDIT FORMULA BAR in excel 2003? why not? where is it? | Excel Worksheet Functions | |||
Hybrid Mode
