How to Use the IMAGINARY Function in WPS on Windows

This how-to guide includes 3 topics for using IMAGINARY, including inserting the function, typing the formula directly, and reviewing syntax details; 3 items are free and 0 items are membership-related.

How-to Index

How-to Guide

1. Insert the function from the Insert Function dialog

Entry point: Formula tab → Insert Function, or the fx button in the formula bar.

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 IMAGINARY in the Insert Function dialog.
4. Select the function and click OK.
5. Enter the required parameters in the Function Arguments dialog.
6. Click OK to finish inserting the formula.

Success Criteria

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

Tips While Using

• Common mistake: A misspelled function name can make the function harder to find.
• Environment note: WPS Spreadsheet must already be open.

2. Type the formula directly in a cell

Entry point: The target cell or the formula bar.

1. Select the cell where you want to enter the formula.
2. Type =IMAGINARY(...) directly in the cell or in the formula bar.
3. Press Enter to confirm.
4. If you want to review parameter hints, type =IMAGINARY( and check the syntax prompt in the editing area.

Success Criteria

• Interface result: The cell shows the calculated result, and the formula bar keeps the full formula.
• What you can do next: You can fill down, copy, or continue editing the formula.

Tips While Using

• Common mistake: Full-width punctuation or an incorrect parameter format can cause a formula error.
• Environment note: Confirm that the cell can calculate formulas before entering the function.

3. Review the function syntax and parameter details

Entry point: Formula tab → Insert Function.

1. Click Insert Function on the Formula tab.
2. Enter IMAGINARY in the search box.
3. Select the function to review its syntax and parameter details.
4. Confirm the parameter format before inserting or editing the formula.

Success Criteria

• Interface result: You can see the IMAGINARY function name and its related description area.
• What you can do next: You can insert the function directly or return to the worksheet and type it manually.

Tips While Using

• Common mistake: Entering the formula before checking the parameter format can lead to an unexpected result.
• Environment note: The position of the description area can vary slightly with different interface layouts.