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, 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.


+-------------------------------------------------------------------+
|Filename: date.zip |
|Download: http://www.excelforum.com/attachment.php?postid=5011 |
+-------------------------------------------------------------------+

 

[lsmft]

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