ODDLPRICE in WPS on Windows FAQ

Last updated:July 20, 2026

Common ODDLPRICE questions usually focus on formula entry, argument references, and result checking; this section covers 3 frequent questions and a short glossary.

FAQ

What should I do if ODDLPRICE shows an error after I enter it?

  1. Check whether the formula starts with =.
  2. Check whether the parentheses, commas, and number of arguments are complete.
  3. Confirm that the date and numeric cells used in the calculation are in the correct format.
  4. Re-enter the formula step by step with the syntax guidance, then press Enter again.

How can I view argument guidance for ODDLPRICE?

  1. Select any editable cell.
  2. Type =ODDLPRICE(.
  3. Watch the syntax guidance that appears in the formula editing area.
  4. Fill in the arguments in order and complete the calculation.

How do I troubleshoot an ODDLPRICE result that does not look right?

  1. Check whether the formula references the correct worksheet and cells.
  2. Confirm that key arguments are not affected by text formatting or blank values.
  3. If you are using a nested formula, test the ODDLPRICE result on its own first.
  4. Change an argument and see whether the result recalculates automatically.

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 cell data from another worksheet in the current formula.
Nested formulaA formula structure in which one function is used inside another formula or function.