excel training - unit
The UK's Number 1 for Microsoft Office Training Add this page to your favourites/bookmarksBookmark page
 
View printable version of pagePrintable version
Plus One Google
Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel training - Unit 2

excel training - Unit 2

resolvedResolved · Low Priority · Version Standard

replyReply Fri 7 Dec 2007, 17:05Delegate Michelle said...

Michelle has attended:
Excel Intermediate course
Excel Advanced course

Unit 2

How do you add another variable such as early repayment charge for loans?

For upcoming training course dates see: Pricing & availability

replyReply Fri 14 Dec 2007, 15:02Trainer Amanda said...

RE: Unit 2

Hi Michelle

Thank you for your question, and apologies for the delay in response.

I assume you are referring to the payment (PMT) function in your question.

Unfortunately this function does not allow you to factor in the variable you mention; and I haven't been able to find an alternative function that would; or way of incorporating this into a calculation - sorry.

Amanda

 

Excel tip:

Outlining - Grouping rows or columns

Highlight want you want to group and press ALT + SHIFT + left cursor arrow

View all Excel hints and tips


Microsoft Certified Partner Accredited Training Provider: Institute of IT Training Institute of Leadership and Management - Certified Courses Security Seal verified by visa, mastercard securecard