There are two other options to use the PMT function. In the Arguments Function dialog box do the same thing mentioned above in option one to see results.

As part of key combos in Word, Excel, and Outlook, they make it easier and faster to perform commonly used commands. Here are 15 of the most essential function-key strokes.

The function should look something like this: "RIGHT (B2,4)." Remove text strings using Excel 2007's "Replace" command. Select all the cells in which you want to replace characters.

In Microsoft Excel, the IMPRODUCT function is an Engineering function; its purpose is to return the product of 1 to 255 complex numbers.

You can't have too many Excel tips. These cover some handy shortcuts, and useful functions for calculation payments or generating random numbers.