How to Use the DGET Function in WPS on Windows

Use the DGET function through 3 topics, including inserting it from the function dialog, typing the formula directly, and reviewing syntax and parameter details; choose a topic from the index and follow the steps.

How-to Index

How-to Guide

1. Insert DGET from the Insert Function dialog

Entry: 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 DGET in the dialog box.
4. Select the function and click OK.
5. Enter each parameter in the Function Arguments dialog box.
6. Click OK to finish entering the function.

Success Criteria

• The current cell contains a DGET function.
• You can see the entered parameters or the calculated result.
• You can continue editing, copying, or adjusting the formula.

Tips While Using

• The database range usually needs a header row.
• The criteria range should correspond to the field names in the data table.
• If the result is not as expected, review the help information or check the parameter ranges again.

2. Type the formula directly in a cell

Entry: Cell → Formula bar

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

Success Criteria

• The DGET formula has been entered in the cell.
• After you press Enter, the cell returns a result or shows an error value.
• You can continue editing the database range, field, or criteria range in the formula bar.

Tips While Using

• Keep the parameter separators correct so the formula can calculate properly.
• If there is no matching record or more than one matching record, check the criteria settings again.

3. Review syntax and parameter details

Entry: Formula tab → Insert Function

1. Click Insert Function on the Formula tab.
2. Type DGET in the search box.
3. Select the function to review its syntax and parameter descriptions.
4. Open the related help entry if you need more detailed guidance.

Success Criteria

• You can see the DGET function name, syntax structure, and parameter descriptions.
• You can identify what range each parameter should reference.
• You can return to the worksheet and continue entering the formula.

Tips While Using

• Syntax guidance is useful when you are using the function for the first time or checking an error.
• If worksheet field names do not match the criteria range, the returned result may be affected.