Forum home » Delegate support and help forum » Microsoft Excel Training and help » training microsoft excel - PMT

training microsoft excel - PMT

ResolvedVersion Standard

Fri 10 Aug 2007, 11:38 Delegate Gary said...

Gary has attended:
Excel Advanced course

PMT

When using the PMT function to calculate a periodic payment, if the interest rate column is already formatted by % do you need to add the % to the calculate formulae.

Fri 10 Aug 2007, 12:18 Trainer Amanda said...

RE: PMT

Hi Gary

Thanks for your question.

If the interest rate is entered into a cell with the % sign (e.g. 5.5%) then you do not need to manually type in the % sign when you are inputting the formula.

Amanda

Training courses

98.2 % recommend us

More live stats...

Training information:

Excel tip:

Trace Dependents / Precedents without the blue arrows

Rather than using the toolbar you can press CTRL+] which is the equivelent of trace dependants and CTRL+[ for precendants. Both of these ways though will not show the blue arrows but jump to the cell containing the formula.

View all Excel hints and tips