Question

1 Approved Answer

Posted on Aug 11, 2024

What excel formula would i input in cell G2 to allow me to calculate the gross pay using the information on these two worksheet in

What excel formula would i input in cell G2 to allow me to calculate the gross pay using the information on these two worksheet in these tables? image text in transcribed

image text in transcribed

Duo Advanced Diedrich Ason Sorter Columns F Duplicate din Dutta Dwa H E Email Address Aron Dorches.com Aaron Nevy.com A Golovice.com ANO Pere Deptid R29 Rube HCSP Retirement 01/1 Posn COMO 20 1008 O:20 Y Y $13.80 $29.38 $24.61 $13.33 $23.38 Y y Y R2 29 29 29 HI2 H12 R29 R29 y Y Awoning.com Y 001219.30 RS23 ODOTTO $12.59 $17.69 $28.35 Sa2.69 $51.91 $24.06 Y Y Y Y Y Y y y Y Y Y Y $17.63 $51.90 Y Employee ID 0000252 00002671 4 00002993 0001018 5 00001054 7 00000125 0000421 90000 10 00004973 11 00005017 2 00050 3 0000512 14 00005 15 00006356 16 00006608 17 00000793 18 602 19 00007219 200007792 21 ODOBN2 22 0000814 20003531 2408951 250009512 2000009 2100010325 20010753 2900010790 3001030 3100010953 32 00011242 33 00011404 340001.2018 15 00012010 30001419 300013749 38 000114 Y Abdullah RI2 R29 H12 R29 Adam.cover.com Adam conocchi R29 Adam Necdcom 29 R29 H12 madeseur Mada.com Adrienne Goldmark once to follow. Clean holdt Select this set Y Y Employee Name Diedrich Aaron Baker, Aaron D Goslovich Aaron Gene Pereira Aaron Gene Minchak Aaron) Schoenbaum Aaron Fishman, Aaron M Huber Aaron Michael Noyce, Aarons Faulkner ANS E Dalberg Dari Abdullah kopulaAbigail Convery. Abigail Carroll, Adam Colvin Adam Conocchioll.Adams Negus, Adams Pope Adam W Mcadams Adesegun Nye Adrian Goldman Adrianne E Cogan Adrienne M Nelson Agnes Kanelin Filardo Ajmer Hiller,Alant Romaine Alan Heidelan Ervin Husted, Alan Ervin Hiendlmayr Alan Demattos Alan Garselis,Alan P Terhaar Alan Anderson Alan W Brown, Albert wu tiler Alden Zumeta Alejandro M EXCEL LABI EMPLOYEES Y D Last Name First Name lorednich Aron Baker Aaron Gosilovich Aaron Pereira Aaron Minchak Aaron Schoenbaum Aaron Fishman Aaron Huber Aaron Noyce Aaron Faulkner Aasa Danila Abdullah Zicopus Abiga Convery Abigail Carroll Adam Colvin Adam Conocchiali Adam Negus Adam Popp Adam Mcadams Adesegun Nye Adrian Goldman Adrienne Cogan Adrienne Nelson Agnes Kane Aislinn Filardo Aimer Hiller Alan Romaine Alan Heide Alan Husted Allan Hiendimaye Alan Dematte Alan Garshells Alan Terhaar Allan Anderson Alan Brown Albert Eiler Alden Zumeta Alejandro PAYROLL DEDUCTION & WH Y y Y Y Y Y 001877 1099 134130 60365570 2030 60043430 1530 60043430 0024200 G 00146420 OS: 240 1063430 102972 OOOOO 00017 0020040 27 SON PL 5.00 02271100 602910 01051 00041710 $41.35 $10.45 $33.30 $37.55 $28.35 $32:55 $12.69 $13.80 $31.58 $40.14 $0.45 S. Y Y Y Y 29 G10 R.29 y Y Alan Hillery.com Al Romain.com Y Y Y Y R29 12 G10 H12 H12 29 H12 R29 G10 y Y Y Alan rendima.com Alan Demattoos.com Alan Gashell.com Alan Terbar.com Alan Ande Alberton.com Alden Cierry.com Alejandro Fumeuy.com Y SALS $40.43 $35.22 $32.69 $20.59 S. $36.50 $26.33 $46.56 Y Y Y 00043130 01001507 R29 Y Ready Stacio Geography 210 Y U Sort Fate Advanced Sort & Fit 3 X Dwaynes Columns F Duplicates Widation Data H I Deduction Tax Withholding M Net N Connections 370013749 1/31/2019 Fren From From Table Recent Duta - Tet/CSV Web Biting ht Range Refresh Source Connections ACC Get & Transfer Data Queries Connections 02 A 1 Employee ID D G 3582 Pay End Date Holiday Vacation Side 1/31/2015 Regular Cross 300002671 1/11/2017 25 SS 3 4 D3 1/11/2019 72 50018 9 1/11/2017 21 6 000054 6 1/11/2015 24 0 7 004125 1/31/2015 80 000121 0 1/11/2019 80 9 000154 0 80 1/11/2019 O 100004973 1/11/2019 0 11 00005017 80 1/11/2019 12 000 17 63 1/11/2019 13 0042 75 1/11/2019 14 BOSS O 1/31/2019 80 14 15 00006356 1/31/2019 0 80 00606 1/11/2015 17 0006790 1/31/2019 80 10 18 to 1/31/2013 30 19 07219 1/31/2013 0 NO 2007 1/11/2019 2 7 21008012 1/31/2015 19 61 > 194 1/31/2015 o 23 531 1/11/2012 11 24 Boi 1/11/2019 9 71 25 009512 1/31/2019 SO 2623 1/31/2015 30 2700010325 1/31/2019 75 2800010753 1/31/2019 80 290010790 1/31/2019 24 56 5010833 1/31/2019 8 22 31 00010959 1/31/2015 O 32 00011242 1/31/2013 0 un 33 00011404 1/31/2015 22 7 13 34012018 1/11/2019 14 66 35 0012036 90012036 1/31/2015 . 36 0013419 1/11/2017 11 03 50 1/31/2019 O 0 1/11/2019 10 1/31/2019 30 41 001590 1/31/2013 80 4200016265 1/31/2013 43 0016409 1/31/2019 80 440016531 1/31/2015 BO 45 0016754 1/31/2013 24 50 EXCEL LAST EMPLOYEES PAYROLL DEDUCTIONS WH 0 OT 0 0 0 O > 0001350 2960014107 40 0015346 0 0 0 Duo Advanced Diedrich Ason Sorter Columns F Duplicate din Dutta Dwa H E Email Address Aron Dorches.com Aaron Nevy.com A Golovice.com ANO Pere Deptid R29 Rube HCSP Retirement 01/1 Posn COMO 20 1008 O:20 Y Y $13.80 $29.38 $24.61 $13.33 $23.38 Y y Y R2 29 29 29 HI2 H12 R29 R29 y Y Awoning.com Y 001219.30 RS23 ODOTTO $12.59 $17.69 $28.35 Sa2.69 $51.91 $24.06 Y Y Y Y Y Y y y Y Y Y Y $17.63 $51.90 Y Employee ID 0000252 00002671 4 00002993 0001018 5 00001054 7 00000125 0000421 90000 10 00004973 11 00005017 2 00050 3 0000512 14 00005 15 00006356 16 00006608 17 00000793 18 602 19 00007219 200007792 21 ODOBN2 22 0000814 20003531 2408951 250009512 2000009 2100010325 20010753 2900010790 3001030 3100010953 32 00011242 33 00011404 340001.2018 15 00012010 30001419 300013749 38 000114 Y Abdullah RI2 R29 H12 R29 Adam.cover.com Adam conocchi R29 Adam Necdcom 29 R29 H12 madeseur Mada.com Adrienne Goldmark once to follow. Clean holdt Select this set Y Y Employee Name Diedrich Aaron Baker, Aaron D Goslovich Aaron Gene Pereira Aaron Gene Minchak Aaron) Schoenbaum Aaron Fishman, Aaron M Huber Aaron Michael Noyce, Aarons Faulkner ANS E Dalberg Dari Abdullah kopulaAbigail Convery. Abigail Carroll, Adam Colvin Adam Conocchioll.Adams Negus, Adams Pope Adam W Mcadams Adesegun Nye Adrian Goldman Adrianne E Cogan Adrienne M Nelson Agnes Kanelin Filardo Ajmer Hiller,Alant Romaine Alan Heidelan Ervin Husted, Alan Ervin Hiendlmayr Alan Demattos Alan Garselis,Alan P Terhaar Alan Anderson Alan W Brown, Albert wu tiler Alden Zumeta Alejandro M EXCEL LABI EMPLOYEES Y D Last Name First Name lorednich Aron Baker Aaron Gosilovich Aaron Pereira Aaron Minchak Aaron Schoenbaum Aaron Fishman Aaron Huber Aaron Noyce Aaron Faulkner Aasa Danila Abdullah Zicopus Abiga Convery Abigail Carroll Adam Colvin Adam Conocchiali Adam Negus Adam Popp Adam Mcadams Adesegun Nye Adrian Goldman Adrienne Cogan Adrienne Nelson Agnes Kane Aislinn Filardo Aimer Hiller Alan Romaine Alan Heide Alan Husted Allan Hiendimaye Alan Dematte Alan Garshells Alan Terhaar Allan Anderson Alan Brown Albert Eiler Alden Zumeta Alejandro PAYROLL DEDUCTION & WH Y y Y Y Y Y 001877 1099 134130 60365570 2030 60043430 1530 60043430 0024200 G 00146420 OS: 240 1063430 102972 OOOOO 00017 0020040 27 SON PL 5.00 02271100 602910 01051 00041710 $41.35 $10.45 $33.30 $37.55 $28.35 $32:55 $12.69 $13.80 $31.58 $40.14 $0.45 S. Y Y Y Y 29 G10 R.29 y Y Alan Hillery.com Al Romain.com Y Y Y Y R29 12 G10 H12 H12 29 H12 R29 G10 y Y Y Alan rendima.com Alan Demattoos.com Alan Gashell.com Alan Terbar.com Alan Ande Alberton.com Alden Cierry.com Alejandro Fumeuy.com Y SALS $40.43 $35.22 $32.69 $20.59 S. $36.50 $26.33 $46.56 Y Y Y 00043130 01001507 R29 Y Ready Stacio Geography 210 Y U Sort Fate Advanced Sort & Fit 3 X Dwaynes Columns F Duplicates Widation Data H I Deduction Tax Withholding M Net N Connections 370013749 1/31/2019 Fren From From Table Recent Duta - Tet/CSV Web Biting ht Range Refresh Source Connections ACC Get & Transfer Data Queries Connections 02 A 1 Employee ID D G 3582 Pay End Date Holiday Vacation Side 1/31/2015 Regular Cross 300002671 1/11/2017 25 SS 3 4 D3 1/11/2019 72 50018 9 1/11/2017 21 6 000054 6 1/11/2015 24 0 7 004125 1/31/2015 80 000121 0 1/11/2019 80 9 000154 0 80 1/11/2019 O 100004973 1/11/2019 0 11 00005017 80 1/11/2019 12 000 17 63 1/11/2019 13 0042 75 1/11/2019 14 BOSS O 1/31/2019 80 14 15 00006356 1/31/2019 0 80 00606 1/11/2015 17 0006790 1/31/2019 80 10 18 to 1/31/2013 30 19 07219 1/31/2013 0 NO 2007 1/11/2019 2 7 21008012 1/31/2015 19 61 > 194 1/31/2015 o 23 531 1/11/2012 11 24 Boi 1/11/2019 9 71 25 009512 1/31/2019 SO 2623 1/31/2015 30 2700010325 1/31/2019 75 2800010753 1/31/2019 80 290010790 1/31/2019 24 56 5010833 1/31/2019 8 22 31 00010959 1/31/2015 O 32 00011242 1/31/2013 0 un 33 00011404 1/31/2015 22 7 13 34012018 1/11/2019 14 66 35 0012036 90012036 1/31/2015 . 36 0013419 1/11/2017 11 03 50 1/31/2019 O 0 1/11/2019 10 1/31/2019 30 41 001590 1/31/2013 80 4200016265 1/31/2013 43 0016409 1/31/2019 80 440016531 1/31/2015 BO 45 0016754 1/31/2013 24 50 EXCEL LAST EMPLOYEES PAYROLL DEDUCTIONS WH 0 OT 0 0 0 O > 0001350 2960014107 40 0015346 0 0 0