WPS Features
Resources
Free AI Tools
Docs Center

How to Use the ODDLPRICE Function in WPS on Windows

Last updated:July 13, 2026

Use the ODDLPRICE function through 3 how-to topics in WPS Spreadsheets; 3 topics are available without membership and 0 topics are membership-related.

How-to Index

No.TopicMembership Requirement
11. Enter ODDLPRICE through the Insert Function dialog boxFree
22. Type the formula directly in a cellFree
33. Review the function syntax and argument detailsFree

How-to Guide

1. Enter ODDLPRICE through the Insert Function dialog box

Entry point: Formulas tab → Insert Function

  1. Select the cell where you want to enter the formula.
  2. Click the fx button in the formula bar, or click Insert Function on the Formulas tab.
  3. Search for ODDLPRICE in the dialog box.
  4. Select the function and click OK.
  5. Enter each argument in the Function Arguments dialog box.
  6. Click OK to finish the formula entry.

Success Criteria

  • The selected cell now contains the ODDLPRICE function.
  • A calculation result appears after the arguments are confirmed.
  • You can continue editing or copy the formula to other cells.

Tips While Using

  • Keep the argument order consistent with the function syntax.
  • Make sure dates, rates, and frequency values use valid data formats.

2. Type the formula directly in a cell

Entry point: Worksheet cell → Formula bar

  1. Select the cell where you want to enter the formula.
  2. Type =ODDLPRICE(...) directly in the cell or in the formula bar.
  3. Press Enter to confirm.
  4. If needed, type =ODDLPRICE( and review the syntax prompt while editing.

Success Criteria

  • The cell shows either the calculation result or the complete formula.
  • The formula bar remains available for further edits.
  • The formula can be filled down or copied to other cells.

Tips While Using

  • Separate arguments with English commas.
  • If an error value appears, check the argument types and references first.

3. Review the function syntax and argument details

Entry point: Formulas tab → Insert Function

  1. Click Insert Function on the Formulas tab.
  2. Type ODDLPRICE in the search box.
  3. Select the function and review the syntax: ODDLPRICE(settlement, maturity, last_coupon, rate, yld, redemption, frequency, [basis]).
  4. Open the related help entry if you need more details.

Success Criteria

  • You can see the full function name and argument order.
  • You can distinguish required arguments from the optional [basis] argument.
  • You can continue to formula entry with the syntax confirmed.

Tips While Using

  • Check the date relationship among settlement, maturity, and last_coupon before entering values.
  • Adjust copied examples to match your actual cell references.