Formula help

[kendallbrett]

Hi all,

I just purchased a new business and inherited a spreadsheet. It contains the folowing formula:

=IF(E165=0,0,-PV(G$25/12,E165,G165/12))

I have not worked with excel much and am trying to get idea, in lamens terms, what it is trying to do. I know the $ sign is an absolute reference, but when I work through the numbers I dont get the same values. Any help would be appreciated.

[sandy666]

PV, one of the financial functions, calculates the present value of a loan or an investment, based on a constant interest rate. You can use PV with either periodic, constant payments (such as a mortgage or other loan), or a future value that's your investment goal.

The IF function is one of the most popular functions in Excel, and it allows you to make logical comparisons between a value and what you expect. In its simplest form, the IF function says:

IF(Something is True, then do something, otherwise do something else)

So an IF statement can have two results. The first result is if your comparison is True, the second if your comparison is False.