Excel PV calculations

[theblueman]

I am trying to find a dialog box I have seen before in Excel that you can calutate PV, FV, PMT, etc.

It has an input where you can put in the rate, Time, pmt, and get your calcuation, just like a financial calculator. I am wondering if I just can't find this on my own Excel or this is a more advanced feature I might not have.

 

[Ted]

Enter the function you want to use with an open parenthesis, for example =npv(, then click on the fx just to the left of the dialog entry box. It will pop up the input box.

 

[theblueman]

Gotcha. Thanks.

 

[Ted]

Alternatively, you can just click on the fx (or go "insert, function"), choose the function you want, and that will open the dialog box.