ODDFRRICE in WPS on Windows FAQ

Last updated:July 20, 2026

When you use ODDFRRICE, the most common questions involve formula entry, parameter formatting, and result checking; this FAQ covers 3 frequent scenarios and includes a short glossary.

FAQ

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

  1. Check whether the formula starts with =.
  2. Confirm that the function name is spelled ODDFRRICE.
  3. Check whether the parentheses, separators, and argument count are complete.
  4. If you use cell references, make sure the referenced cells contain valid dates or numbers.

Why does ODDFRRICE not return the result I expected?

  1. Check whether the settlement date, maturity date, issue date, and first coupon date are entered correctly.
  2. Confirm that the coupon rate, yield, and basis use the correct data format.
  3. Check whether numbers stored as text are being used in the calculation.
  4. Review the parameter order one by one to avoid placing values in the wrong position.

How to use the ODDFRRICE function in WPS on Windows with parameter prompts?

  1. Select the target cell and type =ODDFRRICE(.
  2. Watch for the function syntax prompt near the formula editing area.
  3. Fill in each argument according to the prompt.
  4. If the prompt does not appear, re-enter the function or check whether you are still in formula editing mode.

Glossary

TermDefinition
ODDFRRICEA financial function that returns accrued interest per $100 face value for a security with an odd first period.
ParameterA date, rate, basis, or other calculation input entered in order within a function.
Cell referenceA way to use a cell address in a formula instead of typing a value directly.