calculation using table function

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Calculation using "Table function"

Calculation using "Table function"

resolvedResolved · 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.


 

Excel tip:

Difference between Two Dates

The DATEDIF function computes the difference between two dates. The DATEDIF function is as follows:

=DATEDIF (Date1,Date2,Interval)

Please note that Date1 must be less than (earlier) or equal to Date2

Please note that Interval must be one of the following codes: "d" (in days), "m" (in months), "y" (in years) expressed in quotes


View all Excel hints and tips


Server loaded in 0.09 secs.