Answered

6.1.5 Quiz: Using Spreadsheets in Business

Question 5 of 10

David needs to create a new spreadsheet that will help him determine the payroll deductions for each employee. Which function would he use when he wants the spreadsheet to decide a deduction based on making more than [tex]$10,000 but less than $[/tex]20,000?

A. Nested IF statement
B. Invoice
C. Lookup table
D. Cell protection



Answer :

Final answer:

David should use the Nested IF statement function to determine payroll deductions based on salary ranges.


Explanation:

Nested IF statement would be the function David needs to use in his spreadsheet to decide a deduction based on an employee making more than [tex]$10,000 but less than $[/tex]20,000. This function allows multiple conditions and provides different outcomes based on those conditions.

A Nested IF statement in this scenario could look like: =IF(AND(A1>10000,A1<20000), deduction_amount, "No deduction necessary"). This formula would determine the deduction based on the employee's salary range.

By using a Nested IF statement, David can efficiently calculate accurate payroll deductions for each employee falling within the specified salary range.


Learn more about Nested IF statement function in spreadsheets here:

https://brainly.com/question/14337645