98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Excel Training and help » Calculation using "Table function"
Calculation using "Table function"
Resolved · High Priority · Version 2007
Mayuri has attended:
Excel Advanced course
Calculation using "Table function"
How do I create projection figures on a table for different interest rates if I have one worksheet which contains the formulas. I can put them on different sheets but this will make the workbook size very big. So, I guess there might be a shortcut.
Thanks for your help.
RE: Calculation using "Table function"
Hi Mayuri,
Thank you for your question.
You could try and create a Data Table through the Data menu and use the PMT function or another function in the financial category to try and achieve this.
I hope this answers your question.
Regards
Simon
Mon 23 Feb 2009: Automatically marked as resolved.
Training information:
See also:
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Difference between Two DatesThe DATEDIF function computes the difference between two dates. The DATEDIF function is as follows: |