62.0k views
3 votes
11 The range O5: P6 contains a new set of criteria to identify the one Senior Accountant in Columbus. You want to obtain that person's salary. In cell P8, insert the DGET function to extract the corre

1 Answer

3 votes

Final answer:

You can use the DGET function to extract the salary of the Senior Accountant in Columbus based on specific criteria.

Step-by-step explanation:

To extract the salary of the Senior Accountant in Columbus based on the new set of criteria in the range O5:P6, you can use the DGET function in cell P8. The DGET function allows you to retrieve a value from a database based on specific criteria. In this case, you would use the DGET function to search the range O5:P6 for the salary of the one Senior Accountant in Columbus.

The steps for inserting the DGET function are as follows:

1. The extracted salary should be displayed in cell P8.

2. To initiate the DGET function, type "=DGET(".

3. Indicate the reach and models. For this situation, you need to utilize the reach O5: Use P6 as the range in the database, and then use the criteria in this range to calculate the salary.

4. Enter O5 as the range: P6 as the primary contention of the DGET capability: " =DGET(O5: P6,"

5. Refer to the cells in the range O5 that contain the criteria to specify the criteria: P6. For instance, you would enter "O5" as the second argument if the criteria for identifying the Senior Accountant are in cell O5. =DGET(O5: P6, O5,"

6. Close the capability by adding an end enclosure: " =DGET(O5: P6, O5)"

7. To determine the extracted salary in cell P8, enter the DGET function and press the Enter key.

User SJG
by
8.2k points