Got A Problem, Need Some Help
 

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?


--
lsmft
------------------------------------------------------------------------
lsmft's Profile: http://www.excelforum.com/member.php...o&userid=30678
View this thread: http://www.excelforum.com/showthread...hreadid=560111

Got A Problem, Need Some Help
 

Hi

See attach document.


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

--
jetted
------------------------------------------------------------------------
jetted's Profile: http://www.excelforum.com/member.php...o&userid=17532
View this thread: http://www.excelforum.com/showthread...hreadid=560111

Got A Problem, Need Some Help
 

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?


--
lsmft
------------------------------------------------------------------------
lsmft's Profile: http://www.excelforum.com/member.php...o&userid=30678
View this thread: http://www.excelforum.com/showthread...hreadid=560111