Question: I am having a hard time coming up with a formula and the table. Would it be a Vlookup or Hlookup? D E F G

I am having a hard time coming up with a formula and the table. Would it be a Vlookup or Hlookup?
D E F G H I J K L M 40 Employee ID Dept 41 92-5601 HR 42 77-3407 43 66-1000 ACCTG 44 77-3410 FINANCE 45 95-6688 IT 46 99-8989 HR 47 TOTAL Gross Pay Income Tax 3,000 5,000 15,000 14,000 7,000 4,000 $ 48,000 $ 3. Create a look-up table below Tax Rate look up Table as shown in row 50. Write a formula first for cell 041 with proper function(s) to compute the Income Tax based upon the following schedule: If gross pay
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
