How to Use the ODDLPRICE Function in WPS on Windows

Last updated:July 17, 2026

Use the ODDLPRICE function through 4 how-to topics, all available without membership; start from the How-to Index and follow each entry point and step.

How-to Index

No.TopicMembership Requirement
11. Enter the ODDLPRICE functionFree
22. Fill in the function argumentsFree
33. Use cross-sheet referencesFree
44. Check the result and recalculateFree

How-to Guide

1. Enter the ODDLPRICE function

Entry point: Formulas tab → formula bar

  1. Open WPS Spreadsheet and select the cell where you want the result to appear.
  2. Type = to begin the formula.
  3. Type ODDLPRICE(.
  4. Check that the formula prompt appears and the function name is recognized.

Success Criteria

  • Interface result: =ODDLPRICE( appears in the cell or formula bar.
  • Next action available: You can continue entering arguments.

Tips While Using

  • Start the formula with =.
  • For longer formulas, use the formula bar so the full expression is easier to review.

2. Fill in the function arguments

Entry point: the cell or formula bar after ODDLPRICE( has been entered

  1. Enter each required argument in the prompted order.
  2. Confirm that dates, rate, yield, and other values are placed in the correct positions.
  3. Separate arguments with commas.
  4. Type the closing parenthesis and press Enter.

Success Criteria

  • Interface result: The target cell shows a calculated value or another recognizable numeric result.
  • Next action available: You can select the cell again to review the full formula.

Tips While Using

  • Make sure parentheses are paired correctly.
  • The number and type of arguments need to match the function requirements, or an error value may appear.

3. Use cross-sheet references

Entry point: formula bar

  1. Select the result cell in the current sheet and type =ODDLPRICE(.
  2. Switch to the sheet that stores the input values.
  3. Select the cells you want to use as arguments.
  4. Finish the remaining arguments and press Enter.

Success Criteria

  • Interface result: The formula includes references to cells from another sheet.
  • Next action available: When a referenced cell changes, the result can update as well.

Tips While Using

  • Confirm that each cross-sheet reference points to the intended cell.
  • If inputs are spread across many sheets, organize the input area first.

4. Check the result and recalculate

Entry point: result cell and keyboard shortcut

  1. Check whether the result cell returns the expected value.
  2. Review the date and number formats in referenced cells.
  3. Change one argument and see whether the result updates automatically.
  4. If needed, press F9 to recalculate.

Success Criteria

  • Interface result: The result refreshes after input changes or after manual recalculation.
  • Next action available: You can continue adjusting arguments and comparing outputs.

Tips While Using

  • Numbers stored as text can affect the result.
  • Circular references or incorrect argument formats can cause unexpected output.