PRICEDISC Function in ONLYOFFICE Spreadsheet Editor: Syntax and Examples

=PRICEDISC(DATE(2026,1,15),DATE(2026,7,15),0.10,100,0) is expected to return 95 per 100 face value. Under 30/360 the term is half a year, so a 10% annual discount subtracts 5 from redemption 100.

A discount rate is measured against redemption, not the amount invested. PRICEDISC does not discount a stream of coupons and is not a general present-value formula for compound interest.

=PRICEDISC(settlement, maturity, discount, redemption, [basis])

discount is an annual decimal rate, such as 0.10 for 10%. redemption is the amount at maturity per 100 face value. It is not the full face amount of a holding unless that holding happens to have face 100. There is no frequency parameter.

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 source formula is redemption × (1 − discount × year_fraction). It uses a simple discount convention, not redemption/(1+rate)^years.

1. Enter =DATE(2026,1,15) in A2 and =DATE(2026,7,15) in B2.
2. Enter discount 0.10 in C2 and redemption per 100 100 in D2.
3. Enter basis 0 in E2.
4. Put =PRICEDISC(A2,B2,C2,D2,E2) in F2 and format it as a number.

Independent arithmetic gives 180/360=0.5 years and 100×(1−0.10×0.5)=95. The expected result is a quoted price, not 95% annual return.

There are 181 actual days in this interval. Bases 1 and 3 use 181/365 for this same-year non-leap example; basis 2 uses 181/360. The actual/actual helper’s behavior across multiple calendar years needs its own year-length calculation, so this table is not a universal equivalence of bases 1 and 3.

For a fictional face amount of 10,000, a quote of 95 per 100 corresponds to 10,000×95/100=9,500, before any separate costs. The redemption is 10,000 if the per 100 redemption input is 100. Keep face amount outside PRICEDISC rather than passing 10,000 as though it were a per 100 input and then scaling again.

The holding-period gain is 500 on 9,500, so its simple annualized investment return over 0.5 years is (10,000/9,500−1)/0.5≈10.5263157895%. That differs from the 10% discount rate used to obtain the price. Label the two conventions clearly when comparing quotations.

The inspected source rejects a discount rate less than or equal to zero, nonpositive redemption, settlement at/after maturity, invalid basis or unsupported date serials with #NUM! after conversion. In particular, zero discount is rejected even though the algebraic expression would otherwise equal redemption.

The wrapper does not explicitly reject a computed zero or negative price when discount × year_fraction >= 1. For the half-year setup, discount 2 produces zero and discount 3 produces −50 in the arithmetic. These are source-derived boundary behaviors, not sensible positive-price examples to use in a financial model. Validate a positive remaining factor before relying on the result.

Dates and basis are floored in the source. Supply whole-day DATE values and integer basis codes; a date-text parsing success in one locale does not establish portability in another. No fees, holiday adjustment or intermediate cash flow is inferred from the four required arguments.

Checked October 18, 2026 against the official PRICEDISC 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