ODDFRRICE in WPS on Windows FAQ

Q: What should I do if the ODDFRRICE function returns an error after I enter it?

Check whether the formula starts with = . Review the function name, parentheses, and parameter separators. Use the syntax guidance to confirm the parameter types and count. Edit the formula and press Enter again.

Q: How can I view the ODDFRRICE function guidance?

Select any editable cell. Type =ODDFRRICE( . Review the syntax guidance that appears automatically. Continue editing based on the parameter notes and examples shown there.

When using ODDFRRICE, users usually ask about 3 issue types: input errors, how to view guidance, and incorrect results; this FAQ includes 3 common questions.

FAQ

What should I do if the ODDFRRICE function returns an error after I enter it?

Check whether the formula starts with =.
Review the function name, parentheses, and parameter separators.
Use the syntax guidance to confirm the parameter types and count.
Edit the formula and press Enter again.

How can I view the ODDFRRICE function guidance?

Select any editable cell.
Type =ODDFRRICE(.
Review the syntax guidance that appears automatically.
Continue editing based on the parameter notes and examples shown there.

Why does the ODDFRRICE result look incorrect?

Check whether the referenced cell values are the ones you intended to use.
Confirm that there are no text-formatted numbers, incorrect references, or parameter order issues.
If source data has changed, check whether the formula result has updated as expected.
If needed, break the formula into smaller parts to identify the parameter causing the issue.

Glossary

Term	Definition
ODDFRRICE	A financial function used to calculate the price of a fixed-interest security with an odd first period.
Cross-sheet reference	A way to use data from another worksheet inside the current worksheet formula.
Nested calculation	A calculation method that places another function or expression inside a formula.