Got A Problem, Need Some Help

[lsmft]

Sales Tax Issue:
A1 = Gross Sales
B1 = 4% State S/T
C1 = 1% Local Option S/T
D1 = Gross Sales Tax payable, which is B1 plus C1
E1 = Vendors Compensation which is a break for paying early. One gets to deduct 3% of D1 if paying early.
F1 = another break of .005 % if D1 is over $3000.00 for the amount over $3000.00

I'd like to dedicate G1 to represent the first break of 3% of D1.

I'd like to dedicate H1 to represent the 2nd break of .005% of D1, if D1 qualifies for this break.

Is there a way to get H1 to represent a break if D1 is $3000.00 or more?

[jetted]

Hi

See attach document.

[lsmft]

Thanks Jetted,
however the extra .005 amt of credit is only for the amount of sales tax due that exceeds $3000.00.
Did you formula take that into consideration?