Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
have some problem with database | Excel Discussion (Misc queries) | |||
Urgent Help Required on Excel Macro Problem | Excel Discussion (Misc queries) | |||
Problem With Reference Update | Excel Worksheet Functions | |||
Copy an Drag cell Formula Problem | Excel Discussion (Misc queries) | |||
Freeze Pane problem in shared workbooks | Excel Discussion (Misc queries) |