NOW in WPS on Windows FAQ

Last updated:July 17, 2026

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?

  1. Check whether the formula starts with =.
  2. Check whether the parentheses and symbols are complete and correct.
  3. Re-enter the function and confirm whether the result returns to normal.

How can I view guidance for the NOW function?

  1. Select the target cell.
  2. Type =NOW(.
  3. Review the automatic syntax guidance and example prompt that appears.

Why is the NOW function result incorrect?

  1. Check whether referenced cells contain text-formatted numbers or other abnormal content.
  2. Check whether the worksheet contains circular references or other calculation issues.
  3. Press F9 to recalculate manually and review the result again.

Glossary

TermDefinition
NOW functionA spreadsheet function that returns the current system date and time.
Formula barThe area in a worksheet where you enter and edit formulas.
RecalculationThe process of running formulas again and refreshing the result.