How to Use the DOLLARFR Function in WPS on Windows

Last updated:July 20, 2026

Use DOLLARFR through 4 how-to topics, including entering the function, filling in arguments from syntax guidance, using cross-worksheet references, and building nested formulas.

How-to Index

No.TopicMembership Requirement
11. Enter the DOLLARFR functionFree
22. Fill in arguments from syntax guidanceFree
33. Use DOLLARFR in a cross-worksheet reference3. Use DOLLARFR in a cross-worksheet reference
44. Nest DOLLARFR with other functionsFree

How-to Guide

1. Enter the DOLLARFR function

Entry point: Formulas tab → formula bar

  1. Open Spreadsheet and select the cell where you want to show the result.
  2. Type = in the formula bar or directly in the cell.
  3. Continue by typing DOLLARFR(.
  4. Check whether function syntax guidance appears.

Success Criteria

  • Interface result: The cell enters formula editing mode and shows the DOLLARFR function name.
  • Next action available: You can continue entering arguments and complete the formula.

Tips While Using

  • Common mistake: If you do not type = first, the content may be treated as plain text.

2. Fill in arguments from syntax guidance

Entry point: A cell where =DOLLARFR( has already been entered

  1. Enter the required arguments inside the function parentheses.
  2. Check the argument type and order based on the syntax guidance.
  3. Complete the closing parenthesis after entering the arguments.
  4. Press Enter to confirm the calculation.

Success Criteria

  • Interface result: The cell shows a calculated result.
  • Next action available: You can copy the formula to other cells and continue using it.

Tips While Using

  • Common mistake: Unmatched parentheses or incorrect argument separators can cause a formula error.

3. Use DOLLARFR in a cross-worksheet reference

Entry point: Target result cell → formula bar

  1. Select the cell where you want the result to appear.
  2. Enter a DOLLARFR formula and reference a cell from another worksheet in the arguments.
  3. Check whether the reference address is correct.
  4. Press Enter to return the result.

Success Criteria

  • Interface result: The current worksheet shows the converted result.
  • Next action available: When the source worksheet data changes, the result can update accordingly.

Tips While Using

  • Common mistake: An incorrect worksheet name or cell reference can affect the result.

4. Nest DOLLARFR with other functions

Entry point: Target cell → formula bar

  1. Select the target cell.
  2. Enter a combined formula that includes DOLLARFR.
  3. Check whether the inner and outer function parentheses are complete.
  4. Press Enter to finish the calculation.

Success Criteria

  • Interface result: The cell returns the nested formula result.
  • Next action available: You can continue editing the formula or fill it down.

Tips While Using

  • Common mistake: When the nesting level is deeper, it is easier to miss a parenthesis or reference range.