How to Use the ODDLPRICE Function in WPS on Windows

Last updated:July 20, 2026

Use ODDLPRICE through 3 task topics, including entering the function, working with cross-sheet references, and nesting it inside other formulas; choose a topic from the index and follow the steps.

How-to Index

No.TopicMembership Requirement
11. Enter the ODDLPRICE function and complete a calculationFree
22. Use cross-sheet references with ODDLPRICE argumentsFree
33. Nest ODDLPRICE inside another formulaFree

How-to Guide

1. Enter the ODDLPRICE function and complete a calculation

Entry point: Formulas tab → formula bar

  1. Open WPS Spreadsheets and select the cell where you want the result to appear.
  2. Type = in the formula bar or directly in the cell.
  3. Type ODDLPRICE( and review the syntax guidance that appears.
  4. Enter the required arguments in order.
  5. Press Enter to confirm and display the result in the current cell.

Success Criteria

  • Interface result: The cell shows a calculation result, and the full formula remains visible in the formula bar.
  • Next actions: You can continue editing arguments, copying the formula, or filling it into other cells.

Tips While Using

  • Common mistake: If the formula does not start with =, if parentheses are not closed, or if argument separators are incomplete, the result may not calculate correctly.
  • Environment note: If referenced dates or numeric values are not in the expected format, the result may not display as expected.

2. Use cross-sheet references with ODDLPRICE arguments

Entry point: Formula bar → worksheet tabs

  1. In the result cell, type =ODDLPRICE(.
  2. When entering the first argument, switch to the worksheet that stores the source data.
  3. Select the target cell to insert its reference into the formula.
  4. Repeat the same method for the remaining arguments.
  5. Press Enter and review the returned value in the result cell.

Success Criteria

  • Interface result: The formula contains cross-sheet cell references.
  • Next actions: When source worksheet data changes, the result cell updates accordingly.

Tips While Using

  • Common mistake: Referencing the wrong worksheet or cell directly affects the result.
  • Environment note: If a referenced worksheet is deleted or key data is moved, check the formula references again.

3. Nest ODDLPRICE inside another formula

Entry point: Formula bar

  1. Select the target cell and start typing the outer formula.
  2. At the position where the financial price result is needed, type ODDLPRICE(.
  3. Complete the inner ODDLPRICE arguments as required.
  4. Finish the rest of the outer formula.
  5. Press Enter to view the final result.

Success Criteria

  • Interface result: The cell returns the final result of the outer formula.
  • Next actions: You can continue editing either the outer or inner formula for more advanced analysis.

Tips While Using

  • Common mistake: With deeper nesting, parentheses are easier to misplace.
  • Environment note: It is helpful to verify the ODDLPRICE result on its own before combining it with a more complex formula.