training microsoft excel - PMT

Resolved · Low Priority · Version 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.7 % recommend us
	More live stats...

Training information:

Excel tip:

Sum Up All the Values in A Column

If you want to quickly calculate the Summed values of all cells in a column in Excel 2003 normally you would use the SUM formula. (eg if you wanted to calculate the values in Column C rows 10 to 25) the formula would be:

=SUM(C10:C25)

However, if you keep adding values to column C you would keep having to modify the above SUM formula which can get quite annoying.

To get around this you can sum all the values in a column using the following formula:

=SUM(COLUMN:COLUMN)

Which, in our example, would be:

=SUM(C:C)

NOTE You cannot place this formula in column C, or else Excel 2003 will show a circular reference error.

The formula must be placed in any other column, EXCEPT the one being calculated.

View all Excel hints and tips

Application Training

Training ProgramsProfessional & Management Development

eLearning Solutions

Our Promotions

Our Schedule

Course Formats

Our Clients

training microsoft excel - PMT

PMT

RE: PMT

Excel articles

Excel tip:

Sum Up All the Values in A Column

Training Programs
Professional & Management Development