In Google Sheets, the function PV() is used to calculate the present value of an investment or a loan, based on a specified interest rate, number of periods, and payment amount. The syntax for the function is as follows:

=PV(rate, numberofperiods, paymentamount, [futurevalue], [endorbeginning])

rate: The interest rate per period. This can be a constant value or a reference to a cell containing the rate. numberofperiods: The total number of payment periods over the life of the investment or loan. paymentamount: The amount of each payment made per period. This can be a constant value or a reference to a cell containing the payment amount. futurevalue (optional): The future value or cash balance that you want to attain after the last payment is made. If this argument is omitted, it is assumed to be 0. endorbeginning (optional): A logical value that specifies whether payments are made at the end or beginning of each period. If this argument is omitted, it is assumed to be 0 (payments made at the end of each period).

The PV() function returns the present value of the investment or loan, which is the amount of money that would need to be invested today to achieve the desired future value or to pay off the loan completely.