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

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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!