If Conditions for slab target - URGENT

I have a following requirement to calculate incentive for my team that has slab and percentage. The requirement has 5 conditions -
Condition 1: If Resource 1 monthly target < 0, then Resource should get 0 incentive
Condition 2: If Resource 1 monthly target = target, then Resource should get paid 5% on target
Condition 3: If Resource 1 monthly target > target, then Resource should get paid 5% on target + 10% of the amount upto 2,00,000
Condition 4: If Resource 1 monthly target > 2,00,000, then Resource should get paid 5% on target + 10% of the amount upto 2,00,000 + 15% on the amount upto 3,00,000
Condition 5: If Resource 1 monthly target > 3,00,000, then Resource should get paid 5% on target + 10% of the amount upto 2,00,000 + 15% on the amount upto 3,00,000 + 20% on the balance above 3,00,000

The formula that is currently used is (See Column H) -
=IF(G4<0,0,(IF(E4>200000,((D4*5%)+(G4*10%)+((E4-200000)*15%)),((D4*5%+(G4*10%))))))

This formula has to be tweaked to satisfy condition 3,4,5. Am testing a formula (See Column I). It works good for conditions 1,4,5 but no for 2 & 3.
Attached is the sheet for your reference.

Thanks in advance.

My bad, let me elaborate -
Column D is the SET/Defined/Standard target for every resource by the business.
Column E is the Target Achieved by the resource. This service target is a consolidated amount both the target achieved 'at-work' and 'bridal', hence column F & G
Column F can be ignored for the purpose of our discussion (This is column to distinguish the service done only 'at-work'
Column G is identifier. It calculates & displays if the resource is less or more than his 'Service target at-work' = 'balance'

Please let me know if you need more clarity.