How to Use the IRR Function in WPS on Windows

Use the IRR function through 3 how-to topics, including entering it from Insert Function, typing the formula directly, and reviewing syntax and argument details.

How-to Index

How-to Guide

1. Enter IRR through the Insert Function dialog

Entry path: Formula tab → Insert Function

1. Select the cell where you want to enter the formula.
2. Click the fx button in the formula bar, or click Insert Function on the Formula tab.
3. Search for IRR in the Insert Function dialog box.
4. Select the function and click OK.
5. Enter each argument in the Function Arguments dialog box.
6. Click OK to finish entering the function.

Success Criteria

• Interface result: The target cell now contains an IRR formula.
• What you can do next: You can continue editing arguments, press Enter to confirm, or copy the formula to other cells.

Tips While Using

• Common mistake: A misspelled function name can make IRR harder to find in the search box.
• Environment note: The argument range should contain valid numeric values for calculation.

2. Type the IRR formula directly in a cell

Entry path: Worksheet cell → Formula bar

1. Select the cell where you want to enter the formula.
2. Type =IRR(...) directly in the cell or in the formula bar.
3. Press Enter to confirm the formula.
4. If you want to review argument help, type =IRR( and press F1 to open syntax guidance.

Success Criteria

• Interface result: The cell shows a calculated result, and the formula bar keeps the full formula.
• What you can do next: You can drag the fill handle or copy the formula to other ranges.

Tips While Using

• Common mistake: Incorrect separators or reference ranges can affect the result.
• Environment note: Cash flow data should be arranged in order and include both negative and positive values.

3. Review IRR syntax and argument details

Entry path: Formula tab → Insert Function

1. Click Insert Function on the Formula tab.
2. Type IRR in the search box.
3. Select the function and review the syntax IRR(values, [guess]).
4. Click the help link for the function to open more details.

Success Criteria

• Interface result: You can see the function name, syntax structure, and argument details.
• What you can do next: You can return to the worksheet and continue entering or editing the formula.

Tips While Using

• Common mistake: Checking only the function name without confirming argument order can lead to input errors.
• Environment note: Opening a help link usually requires a network connection.