This FAQ covers 3 common questions about entering the NOW function, viewing syntax guidance, and refreshing results in WPS Spreadsheets on Windows.
FAQ
What should I do if the NOW function shows an error?
- Check whether the formula starts with
=. - Check whether the parentheses and symbols are complete and correct.
- Re-enter the function and confirm whether the result returns to normal.
How can I view guidance for the NOW function?
- Select the target cell.
- Type
=NOW(. - Review the automatic syntax guidance and example prompt that appears.
Why is the NOW function result incorrect?
- Check whether referenced cells contain text-formatted numbers or other abnormal content.
- Check whether the worksheet contains circular references or other calculation issues.
- Press F9 to recalculate manually and review the result again.
Glossary
| Term | Definition |
|---|---|
| NOW function | A spreadsheet function that returns the current system date and time. |
| Formula bar | The area in a worksheet where you enter and edit formulas. |
| Recalculation | The process of running formulas again and refreshing the result. |