rawah alsandi R4 - AutoSave C 2 _ LOOKUPfunction - saved Search File Home Insert Draw Page Layout Formulas Data Review View Help Power Pivot AUTOSAVE TURNED OFF This workbook contains features that prevent it from using AutoSave. Please save your workbook manually. 0 x Comments Share 2 A B C D E G H I J K L M N O P Q R S T U V W X Y Income Tax 40 Employee ID Dept 41 92-6001 HR 42 77-3407 IT 43 66-1000 ACCIG 44 77-3410 FINANCE 45 95 0088 IT 46 99-8989 HR 47 TOTAL Gross Pay 3.000 5.000 15,000 14,000 2. Create a look-up table below Tax Rate look up Table as shown in row 60. Write a formula first for cell 041 with proper functions to compute the Income Tax based upon the following schedule If gross pay 08,000, the tax rate is 10% If grass pay 7,000, the tax rate la 20%. If gross pay