ODDLPRICE in WPS on Windows FAQ

Last updated:July 17, 2026

Common questions about ODDLPRICE usually involve formula entry, argument order, and result checking; this FAQ includes 4 practical questions and a 4-term glossary.

FAQ

What should I do if ODDLPRICE returns an error?

  1. Check whether the formula starts with =.
  2. Make sure the parentheses are complete and the arguments are separated correctly.
  3. Review the argument count and order shown in the formula prompt.
  4. If the error remains, check the date and number formats in referenced cells one by one.

How can I view the argument prompt for ODDLPRICE?

  1. Select the target cell.
  2. Type =ODDLPRICE(.
  3. Look for the syntax prompt near the formula bar.
  4. Continue entering the arguments based on the prompt.

Why does the calculated result look incorrect?

  1. Check whether referenced cells contain numbers stored as text.
  2. Confirm that each date argument is entered in the correct position.
  3. Check for circular references or references to the wrong sheet.
  4. After making corrections, press Enter again or press F9 to recalculate.

Do I need a membership to use ODDLPRICE in WPS on Windows?

  1. Open any workbook in WPS Spreadsheet.
  2. Select a cell and type =ODDLPRICE(.
  3. Enter the arguments and run the calculation normally.
  4. If the result returns as expected, you can continue using it; the feature description shows no membership restriction.

Glossary

TermDefinition
ODDLPRICEA financial function that returns the price per 100 face value of a security with an odd last coupon period.
Cross-sheet referenceA way to use a cell from another worksheet inside the current formula.
Automatic recalculationThe spreadsheet behavior that refreshes formula results when dependent values change.
Formula promptThe on-screen syntax hint that shows argument order, format, or examples while you type a function.