RECEIVED Function in Google Sheets: Formula, Examples & Troubleshooting

=RECEIVED(settlement, maturity, investment, discount, [day_count_convention])

The required inputs are settlement, maturity, investment amount, and discount rate. The optional convention defaults to 0. Google names codes 0 US NASD 30/360, 1 Actual/Actual, 2 Actual/360, 3 Actual/365, and 4 European 30/360. It recommends DATE or another date conversion instead of text. Google RECEIVED reference.

Keep investment as an amount and discount as a percentage. RECEIVED is not a transaction-history query: it calculates a model result and does not verify that an issuer will pay or that funds have arrived.

Use the following hypothetical assumptions:

1. Enter =RECEIVED(B2,B3,B4,B5,B6) in B8.
2. Display the result as an amount.
3. The independently expected maturity amount is 10,000.
4. Enter =B8-B4 in B9. The expected difference between maturity amount and investment is 200.

For these non-month-end 30/360 dates, the fraction is 180/360, or one-half. The audit solves this discount relationship:

9800 = maturity_amount * (1 - 0.04 * 180/360)
maturity_amount = 9800 / 0.98 = 10000

The return is not calculated as 9800*(1+4%/2), which would give 9,996. That expression applies simple interest to the amount invested rather than reversing a discount measured against maturity amount. The distinction explains the four-unit difference in this example.

Place bases 0, 2, and 3 in D2:D4. In E2 use =RECEIVED($B$2,$B$3,$B$4,$B$5,D2) and fill down.

The actual calendar difference is 181 days. The different denominators and the simple 30/360 convention explain the three results. Do not change the basis merely to force a desired round redemption amount; it belongs to the contract or model assumption.

For the Actual/365 row, the independent audit is:

=B4/(1-B5*(B3-B2)/365)

Using twice the investment, 19,600, with that same basis and rate gives approximately 19,996.645796, twice the original basis-3 result. This is a useful scale check when consolidating positions. It does not establish that a real instrument is available in arbitrary denominations.

B8 is a maturity amount; B9 is a separate difference calculation. Neither by itself is an annual percentage yield. For the original 30/360 example, 200/9800 is the holding-period gain fraction, approximately 2.040816%, not the quoted annual discount rate of 4%.

The model does not include an unstated fee, tax, missed payment, reinvestment policy, or credit adjustment. Keep those assumptions separate if your broader worksheet needs them. These synthetic numbers explain a function and are not a recommendation about an actual investment.

• A result is close but not exact: check the basis and whether you modeled discount or interest. They use different reference amounts.
• The result is off by a factor of 100: inspect the rate’s stored value and formatting. Four percent is 0.04.
• Dates are reversed or text: use explicit DATE values and verify maturity is after settlement before interpreting an output.
• The audit denominator approaches zero: 1-discount*year_fraction becomes unstable near zero and nonpositive beyond it. Reconsider the assumptions; this guide does not promise a specific native error code for that case.
• Month-end or leap-year behavior: the displayed arithmetic covers the stated simple dates only. The source names conventions but does not supply a complete implementation or exhaustive invalid-input table.

Google currently documents RECEIVED. Its introduction, retirement, and last functioning version were not established. No cross-product equivalence is assumed.

Reviewed October 17, 2026: Google RECEIVED and Google DATE.

Related published guides: DATE, DAYS360, and ROUND.