How to Use the DOLLAR Function in WPS on Windows

This how-to guide includes 4 operation topics, all available without membership; choose a topic from the index and follow the entry path and steps below.

How-to Index

How-to Guide

1. Enter the DOLLAR function

Entry path: Formula tab → formula bar

1. Open WPS Spreadsheet and select the cell where you want to show the result.
2. Type = in the formula bar or directly in the cell.
3. Type DOLLAR(.
4. Review the syntax prompt and example shown on screen.

Success Criteria

• Interface result: =DOLLAR( appears in the formula bar or selected cell.
• Next action available: You can continue entering arguments and complete the formula.

Tips While Using

• Start the formula with =.
• For longer formulas, use the formula bar so the full expression is easier to review.

2. Fill in the function arguments

Entry path: a cell or formula bar that already contains =DOLLAR(

1. In the first argument position, enter a number, a cell reference, or a formula that returns a number.
2. If needed, enter the number of decimal places in the second argument position.
3. Check that the parentheses and separators are complete.
4. Press Enter to confirm.

Success Criteria

• Interface result: The cell shows a currency-formatted text result.
• Next action available: You can copy the formula to other cells.

Tips While Using

• Make sure the argument count and argument types match the function syntax.
• Parentheses must be paired correctly.

3. Use DOLLAR with cross-sheet references

Entry path: target worksheet cell → formula bar

1. Select the result cell in the target worksheet.
2. Enter a DOLLAR formula and reference a cell from another worksheet in the argument.
3. If needed, nest another function inside DOLLAR, or wrap another formula with DOLLAR.
4. Press Enter to view the result.

Success Criteria

• Interface result: The current worksheet shows currency-formatted text based on a referenced value from another sheet.
• Next action available: You can continue adjusting the reference or nested formula.

Tips While Using

• Confirm that the referenced cell contains a value that can be calculated as a number.
• For longer nested formulas, check the syntax in smaller parts first.

4. Check automatic result updates

Entry path: a result cell that already uses DOLLAR

1. Change the source cell referenced by the DOLLAR formula.
2. Watch whether the result cell updates at the same time.
3. If the result does not change as expected, check for an incorrect reference.
4. If needed, trigger recalculation and review the result again.

Success Criteria

• Interface result: The result cell updates after the source data changes.
• Next action available: You can continue editing source values and verifying the output.

Tips While Using

• If the result looks wrong, first check whether the referenced value is stored as text or whether a circular reference exists.
• Manual recalculation can help when you are troubleshooting a temporary display issue.