Formulas > =RECEIVED()
How to Use RECEIVED() in Google Sheets
Description
How To Actually Use RECEIVED() in Sheets
RECEIVED(settlement, maturity, investment, discount, [day_count_convention])
Try RECEIVED yourself
Use the RECEIVED formula to calculate the amount received at maturity for an investment. Use the range A1:E1 for settlement, maturity, investment, discount, and day_count_convention respectively.
Hints (2)
-
Make sure to input the correct cell references for each parameter.
-
Remember that the day_count_convention is optional.
Looking for a video tutorial? Members can email me anytime! Check out the blogs below for more info on this formula. Or generate your formula. Find more formulas here at BetterSheets.co/formulas
Learn more about the RECEIVED() formula:
Generate a RECEIVED() formula for your needs
Describe your task in plain English and get a paste-ready formula that uses RECEIVED(). 2 free AI generations, no signup. Members get unlimited use.
Generate a RECEIVED() formula