RECEIVED Function (Calligra Sheets)

• Introduced: Original introduction release not established; the inspected release is not an introduction date.
• Available: Registered in Calligra Sheets 26.08.2, verified from first-party released source retrieved on October 18, 2026.
• Retired or deprecated: Neither is established by the inspected sources. The function remains registered; retirement and deprecation are different claims.
• Evidence: Selected formulas were executed in the Calligra Sheets 25.04.2 GUI on October 18, 2026. The native-results section lists those observations separately from independent arithmetic and source analysis. 26.08.2 was source-checked only.
• Entry style: English function names, semicolon argument separators and decimal points. Use DATE constructors instead of ambiguous date text. Optional-argument brackets shown in syntax are not entered literally.

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

Four or five arguments are accepted. The calculation is investment / (1 − discount × year_fraction). For ordinary positive-proceeds examples, keep the denominator strictly positive. There is no coupon frequency, interim-payment list or compounding option.

On a fresh worksheet put =DATE(2025;1;1) in B1, =DATE(2025;7;1) in B2, 950 in B3, 0.1 in B4 and 0 in B5. Label the cells settlement, maturity, investment, discount and basis.

1. Enter =RECEIVED(B1;B2;B3;B4;B5) in B7.
2. Expect 1000. This is the total maturity amount, not just the profit.
3. In B8 enter =B7-B3 to isolate the independently expected 50 gain.
4. Check the denominator: the ordinary basis-0 interval is 180/360 = 0.5, so 1−0.1×0.5 = 0.95, and 950/0.95 = 1000.

The discount itself is 10% annually of maturity proceeds, applied for half a year: 1000 × 0.1 × 0.5 = 50. Deducting that amount from maturity proceeds gives the original 950 investment.

For basis 3 the actual interval is 181 days, so the calculation is 950 / (1 − 0.1×181/365). With zero discount, the denominator is 1 and the maturity amount equals the investment. The source does not reject zero discount.

A positive rate input must be entered as 0.1 or 10%, not 10. Entering 10 means 1000% annually and can make the denominator negative for a half-year interval. A numerical return from the function does not certify that such a model is financially meaningful.

For this function, basis 0 defaults to the financial helper’s simplified US 30/360 method; 1 counts actual days divided by the number of days in the settlement year; 2 uses actual/360; 3 uses actual/365; 4 uses a simplified European 30/360 calculation.

The 0/4 helpers are not full end-of-month normalization algorithms. Basis 0 has a special February-start adjustment; basis 4 is simply 30 times the month difference plus the day difference. Basis 1 uses the settlement year’s 365/366 denominator even across a year boundary. Do not infer full market-convention correctness from the labels. These helpers also differ from the shared YEARFRAC implementation used by DISC. See released date helpers.

The model can be checked backward: with maturity proceeds 1000, discount 0.1 and a half-year fraction, the required investment is 1000 × (1−0.1×0.5) = 950. RECEIVED reverses that relation. This inverse check is a useful way to detect whether a source quote is a discount rate or an investment-base interest rate.

For the same 950-to-1000 cash flow, the holding-period gain relative to investment is 50/950 = 5.2631578947%. Annualized simply over a half year, it is 10.5263157895%, not the 10% discount quote. Do not compare these percentages as if their denominators were identical.

If a planning sheet receives an investment-base rate instead of a discount rate, inserting it directly into RECEIVED changes the model. Confirm the quote convention and retain labels such as “discount rate” and “maturity proceeds”. The function does not include taxes, fees, reinvestment or intervening payments.

For nonpositive elapsed day count, invalid year denominator or basis outside 0–4, the source returns Boolean FALSE. The selected 25.04.2 native test confirmed Boolean FALSE for equal ordinary dates. This is different from numeric zero and can be silently coerced to zero by downstream arithmetic.

If the denominator 1−discount×d/y is exactly zero, the source instead returns #VALUE!. For January 1 to July 1, 2025 under basis 0, discount 2 gives 1−2×0.5 = 0, so =RECEIVED(DATE(2025;1;1);DATE(2025;7;1);950;2;0) displayed #VALUE! in the selected 25.04.2 native run. These paths must not be collapsed into a generic borrowed error table.

• Require a valid positive interval and an intended basis before evaluation. Preserve Boolean output types when exporting/checking results.
• Check that the denominator is positive, not merely nonzero. The source explicitly rejects zero but does not reject a negative denominator; negative proceeds can therefore appear for unsuitable inputs.
• The body does not explicitly reject nonpositive investment or negative discount. Establish sensible economic input bounds separately instead of treating every returned number as a valid product quote.
• Very small positive denominators magnify input changes and can produce huge proceeds. Inspect the rate, date fraction and quote convention rather than trusting formatted currency output.
• Keep invalid date text, fractional basis conversion, blanks and imported errors outside the ordinary example until native behavior is verified.

The Financial module registers COM.SUN.STAR.SHEET.ADDIN.ANALYSIS.GETRECEIVED as an alternate name for RECEIVED. It invokes the same implementation. An alias registration does not establish a workbook import/export guarantee, identical error behavior in other products or availability in every packaged build.

• DATE creates explicit settlement and maturity inputs.
• YEARFRAC uses a separate helper and is not automatically equivalent at edge dates.
• SUM can aggregate individually validated maturity amounts.
• KDE RECEIVED handbook documents the function interface.
• Released function implementation provides the actual validation and calculation rules.

These formulas were recalculated in Calligra Sheets 25.04.2 from a prepared ODS workbook and saved by the application. The table records the native-saved results. Other scenarios remain independent expectations or source analysis unless listed here.

Screenshot: Native Calligra Sheets 25.04.2. Selected cell B2 evaluates =RECEIVED(DATE(2025;1;1);DATE(2025;7;1);950;0.1) and displays 1000.0000000000. Column B contains application results; column C contains the corresponding formula text. The visible false results were saved with Boolean type, distinct from numeric zero.

These observations cover only the listed cases in 25.04.2. They do not establish execution in 26.08.2, another locale, general workbook compatibility or the economic validity of unsuitable inputs.