Error calculating Superannuation deductions

[PistolPete7]

This is what I have come up with to comply with the specifications, Cannot figure out where I am going wrong (quite new to excel so don't drill me if it's crap)

Specifications: Project managers + Testers (specifically) get a 10% deduction off salary (The salaries in cells H27-H33) , All other employees over 50 get an 8% deduction off salary and employees under 50 get a 6% bonus salary

[mikeTRON]

Can you use helper columns? I would suggest doing do if you can because you are going down the right path but it seems you are trying to do too much at once (which also makes the file harder to audit).
Can you post a sample workbook with a few solved (hard-coded) examples?

[PistolPete7]

I tried Using column helper but didn't get much benefit out of it, Posted a copy of the workbook, I don't know what a (Hard-coded example is lol)

[mikeTRON]

Manually type in the answer you are trying to get to and show us where that cell is, so we can see how to automate it with formulas.
Hard-coded is literally typed in, instead of using a formula.

[PistolPete7]

Alright will do that now, will re-upload the file with it in

[JohnTopley]

See attached:

Added 2 columns to your job salary table for <50 and > 50. For Project Managers and Testers both columns contain 10%.

in K5

=VLOOKUP($C5,$G$28:$J$33,2,0)*VLOOKUP($C5,$G$28:$J$33,IF((TODAY()-$D5)/365<50,3,4),0)

Copy down

[CAntosh]

If I'm understanding you correctly, then try the formula below in K5 (or whichever column, row 5) and fill down. It should return 10% of the corresponding H28:H33 value if the employee is a tester or Project Manager, 8% if he/she is not in one of those roles but is over 50, and 6% if the previous two conditions are both false.

=IF(OR($C5="Project Manager",$C5="Tester"),VLOOKUP($C5,$G$28:$H$33,2)*0.1,IF(DATEDIF(D5,TODAY(),"Y")>50,VLOOKUP($C5,$G$28:$H$33,2)*0.08,VLOOKUP($C5,$G$28:$H$33,2)*0.06))

[PistolPete7]

Thank's Cantosh, that worked correctly