PRICE()

Description

Calculates the price of a security paying periodic interest, such as a US Treasury Bond, based on expected yield.

How To Use in Sheets

PRICE(settlement, maturity, rate, yield, redemption, frequency, [day_count_convention])

External Links

0Better Sheets Tutorials

No videos featuring this formula, yet. Stay tuned! In the mean time check out blogs below, and more formulas here at Better Sheets.