How to Use the DOLLAR Function in WPS on Windows

Last updated:July 20, 2026

This how-to guide includes 4 operation topics for the DOLLAR function, and all 4 are available without membership; choose a topic from the index and follow the steps.

How-to Index

No.TopicMembership Requirement
11. Enter the DOLLAR functionFree
22. Fill in arguments by syntaxFree
33. Use it with cell referencesFree
44. Check results and recalculateFree

How-to Guide

1. Enter the DOLLAR function

Entry point: Formulas tab → formula bar

  1. Open WPS Spreadsheets and select the cell where you want the result to appear.
  2. Type = in the formula bar or directly in the cell.
  3. Continue by typing DOLLAR(.
  4. Check whether syntax guidance appears in the editing area.

Success Criteria

  • On-screen result: The cell enters formula input mode.
  • What you can do next: You can continue entering arguments and complete the formula.

Tips While Using

  • Common mistake: If you do not start with =, the content may be treated as plain text.
  • Environment note: The worksheet must be editable.

2. Fill in arguments by syntax

Entry point: Formula input mode after selecting the target cell

  1. After DOLLAR(, enter the number, cell reference, or formula result you want to convert.
  2. If needed, enter the separator and then add the decimals argument.
  3. Check that the parentheses are complete.
  4. Press Enter to confirm the formula.

Success Criteria

  • On-screen result: The cell shows a currency-formatted text result.
  • What you can do next: Select the cell again to review the full formula in the formula bar.

Tips While Using

  • Common mistake: Unmatched parentheses or incorrect argument separators can cause a formula error.
  • Environment note: The arguments must match the function requirements.

3. Use it with cell references

Entry point: Formula bar

  1. Select the result cell and type =DOLLAR(.
  2. Click the cell that contains the original amount to use it as an argument.
  3. If needed, add the decimals argument to control precision.
  4. Press Enter to finish the formula.

Success Criteria

  • On-screen result: The result cell shows currency-formatted text based on the referenced data.
  • What you can do next: When the referenced cell changes, the result updates as well.

Tips While Using

  • Common mistake: Referencing text-formatted numbers or the wrong cell can affect the result.
  • Environment note: For cross-sheet references, confirm that the reference address is correct.

4. Check results and recalculate

Entry point: A worksheet where the formula has already been entered

  1. Change the source data referenced by the DOLLAR function.
  2. Check whether the result cell updates automatically.
  3. If the result does not change as expected, review the formula and references.
  4. Recalculate the worksheet if needed, then confirm the result again.

Success Criteria

  • On-screen result: The result changes when the source data changes.
  • What you can do next: You can copy the formula or extend it to other cells.

Tips While Using

  • Common mistake: The result is text, so confirm its text nature before using it in later numeric summaries.
  • Environment note: In complex worksheets, also review the full reference chain.