TBILLPRICE in Collabora Office: Calculate a Treasury-Bill Price per 100

=TBILLPRICE(Settlement; Maturity; Discount)

Settlement is the purchase date. Maturity is the expiry date. Discount is the percentage discount on acquisition. All three arguments are required; there is no optional Basis, redemption-value, or coupon-frequency argument.

Enter 9% as 9% or 0.09, not 9. The output is quoted per 100 units. Buying a larger face amount changes the total cash price proportionally, but does not change this quoted per-100 price.

Use DATE or genuine date cells so a date-looking subtraction expression is not accidentally passed to the function.

Put =DATE(1999;3;31) in A2, =DATE(1999;6;1) in B2, and 9% in C2. In D2 enter =TBILLPRICE(A2;B2;C2).

The documented expected result is 98.45. There are 62 actual days between the dates. The independent arithmetic consistent with the control is:

=100*(1-C2*(B2-A2)/360)

It gives 100×(1−0.09×62/360)=98.45. The discount amount per 100 par is 1.55. This independently reconstructs the source example; it is not a native execution or a full boundary contract.

For a hypothetical face amount of 5000, use =D2/100*5000. The independent cash price is 4922.5, and the difference from face amount is 77.5.

Keep quoted price, face amount, and total cash price in separate labeled cells. Multiplying 98.45 directly by 5000 would be off by a factor of 100 because the quote is per 100, not per one.

This calculation excludes fees, taxes, and settlement adjustments. The function does not retrieve a live market quote or establish an available transaction price.

Use settlement 2026-01-01, maturity 2026-06-30, and discount 4%. The actual interval is 180 days. The independent price model gives 100×(1−0.04×180/360)=98.

The corresponding function call is =TBILLPRICE(DATE(2026;1;1);DATE(2026;6;30);4%), with independent expected price 98. Both this case and the vendor control stay within one calendar year and a short holding period.

For an audit, independently calculate the date difference in a numeric cell. Do not substitute a nominal six months for the actual 180-day interval without checking the dates.

For the source price 98.45, the holding-period gain relative to invested price is 1.55/98.45, approximately 1.574403250%. The discount relative to par is 1.55/100=1.55%.

Those use different denominators. Multiplying either by an annualization factor gives different rates, so the input Discount should not be relabeled as a generic investment return.

A separate 360-day simple investment-yield calculation gives (100−98.45)/98.45×360/62, approximately 9.1416962925%. It differs from the 9% discount input even though it describes the same price/date example.

Check date order, percentage scale, and the per-100 output convention. The dedicated section does not fully state maximum maturity span, invalid-input error codes, or native date coercion behavior. This guide does not import those limits from another spreadsheet or another treasury-bill function.

The independent arithmetic is established for the ordinary examples shown, not every long-dated or boundary case. If a result is negative or unexpectedly large, inspect the discount and elapsed days before applying ROUND to hide the issue. Preserve unrounded values for an audit, and round only according to the reporting requirement.

The exact function is documented in Collabora Office 26.04 desktop help, retrieved and reviewed on October 17, 2026. This establishes a documentation scope, not the first release that introduced the function or the last version in which it works; those versions and any retirement date remain unestablished. Collabora Online and mobile support are not inferred from desktop help, nor is behavior in another spreadsheet product.

The examples are documentation-based expectations with independent calculations. They have not been executed in Collabora Office. No application screenshot or native error/coercion certification is implied. Formulas use English function names and semicolon argument separators.

• Collabora Office 26.04: TBILLPRICE (checked October 17, 2026).
• Editorial testing standards.