RECEIVED Function in ONLYOFFICE Spreadsheet Editor: Syntax and Examples

=RECEIVED(DATE(2026,1,15),DATE(2026,7,15),950,0.10,0) is expected to return 1000. The input 950 is an invested monetary amount, so the result 1000 is in the same monetary units. Unlike a per 100 price function, RECEIVED does not normalize the amount to face 100.

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

investment is a positive amount paid and discount is an annual discount rate as a decimal. A discount rate is applied to the amount received at maturity. It is not an ordinary interest rate applied to the investment.

Basis defaults to 0 when omitted. The documented codes are 0 US (NASD) 30/360, 1 actual/actual, 2 actual/360, 3 actual/365 and 4 European 30/360. Use DATE for unambiguous numeric dates, settlement strictly before maturity, and consistent monetary units. Brackets mark optional syntax and are not typed.

The implementation evaluates investment / (1 − discount × year_fraction). The denominator must be strictly positive for the intended positive finite maturity amount. The function has no payment-frequency parameter or interim-cash-flow input.

1. Put =DATE(2026,1,15) in A2 and =DATE(2026,7,15) in B2.
2. Enter investment 950 in C2, discount 0.10 in D2 and basis 0 in E2.
3. Enter =RECEIVED(A2,B2,C2,D2,E2) in F2.
4. Format F2 as a number or currency using the same unit as C2.

Under 30/360, the term is 0.5 years. The denominator is 1−0.10×0.5=0.95, and 950/0.95=1000. The difference 50 is the gain in currency units, not a 50% rate.

The scaling control doubles the invested amount while holding dates and discount fixed, so it doubles the output. The 20% example uses denominator 0.9. These are independent algebraic checks, not observed application outputs.

Applying a 10% simple interest rate to investment 950 for half a year would give 950×(1+0.10×0.5)=997.5. RECEIVED gives 1000 because its 10% is a discount rate measured against the maturity amount. The 50 gain divided by 950 and 0.5 produces an investment-based annualized rate of approximately 10.5263157895%.

To verify the discounted relationship,1000×(1−0.10×0.5)=950 reconstructs the starting investment. Retain the denominator convention next to the input rate so another user does not substitute a yield or an interest quote without conversion. Transaction fees and interim payments would require additional modeling decisions; they are not encoded here.

The source rejects nonpositive investment, nonpositive discount, settlement at/after maturity, invalid basis and unsupported date serials. A negative computed result is returned as#NUM!. A zero discount is therefore not a supported identity test for this implementation.

Do not rely on the function to provide a particular friendly error at the singularity discount × year_fraction = 1: the wrapper has no explicit zero-denominator guard before the division. The guide does not claim a native error code or display for that case. Validate 1−discount×year_fraction > 0 in the model before calling it; as the denominator approaches zero, the result becomes extremely sensitive to small changes.

For the half-year setup, discount greater than 2 makes the denominator negative and follows the source’s negative-result error path. Such extreme cases are useful validation boundaries, not realistic examples. Dates and basis are floored after numeric conversion; use explicit whole-day dates and integer basis values to avoid accidental changes to the model.

Checked October 18, 2026 against the official RECEIVED help and official SDKJS source tagged v10.0.0.169. Desktop Editors 10.0 was released October 13, 2026. The original introduction version for this individual function is not established; current help does not mark it retired or deprecated.

All results in this guide are expected values from documentation, source inspection and independent arithmetic, not application observations. Neither the application nor its calculation engine was used to test these examples. The tag matches the installed version/build designation but does not establish identical behavior in every older release, mobile client, server deployment or imported workbook. Examples use English names and comma argument separators; adapt separators to editor settings. These fictional calculations explain a function, not an investment or borrowing recommendation.

• DATE
• RATE
• PV