Formula code needed

[bill85310]

Hi,
I am not a excel expert, so I would imagine this is going to be easy for someone.
I have created an invoice for my customers; some of the items should have an 8% sales tax applied. I want to be able the test for a flag; sum the total and calculate the sales tax.
<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o> </o>
<TABLE class=MsoNormalTable style="MARGIN: auto auto auto 5.15pt; WIDTH: 439.05pt; BORDER-COLLAPSE: collapse; mso-padding-alt: 0in 5.4pt 0in 5.4pt" cellSpacing=0 cellPadding=0 width=585 border=0><TBODY><TR style="HEIGHT: 12.75pt; mso-yfti-irow: 0; mso-yfti-firstrow: yes"><TD style="BORDER-RIGHT: windowtext 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: windowtext 1pt solid; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: windowtext 1pt solid; WIDTH: 48pt; PADDING-TOP: 0in; BORDER-BOTTOM: windowtext 1pt solid; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent; mso-border-alt: solid windowtext .5pt" vAlign=bottom noWrap width=64>

Hidden field <o></o>​

</TD><TD style="BORDER-RIGHT: windowtext 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: windowtext 1pt solid; PADDING-LEFT: 5.4pt; BACKGROUND: silver; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; WIDTH: 53pt; PADDING-TOP: 0in; BORDER-BOTTOM: windowtext 1pt solid; HEIGHT: 12.75pt; mso-border-top-alt: solid windowtext .5pt; mso-border-bottom-alt: solid windowtext .5pt; mso-border-right-alt: solid windowtext .5pt" vAlign=bottom noWrap width=71>

Quantity<o></o>​

</TD><TD style="BORDER-RIGHT: windowtext 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: windowtext 1pt solid; PADDING-LEFT: 5.4pt; BACKGROUND: silver; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; WIDTH: 28.05pt; PADDING-TOP: 0in; BORDER-BOTTOM: windowtext 1pt solid; HEIGHT: 12.75pt; mso-border-top-alt: solid windowtext .5pt; mso-border-bottom-alt: solid windowtext .5pt; mso-border-right-alt: solid windowtext .5pt" vAlign=bottom noWrap width=37>

Tax<o></o>​

</TD><TD style="BORDER-RIGHT: windowtext 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: windowtext 1pt solid; PADDING-LEFT: 5.4pt; BACKGROUND: silver; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; WIDTH: 206pt; PADDING-TOP: 0in; BORDER-BOTTOM: windowtext 1pt solid; HEIGHT: 12.75pt; mso-border-top-alt: solid windowtext .5pt; mso-border-bottom-alt: solid windowtext .5pt; mso-border-right-alt: solid windowtext .5pt" vAlign=bottom noWrap width=275>

Description<o></o>​

</TD><TD style="BORDER-RIGHT: windowtext 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: windowtext 1pt solid; PADDING-LEFT: 5.4pt; BACKGROUND: silver; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; WIDTH: 56pt; PADDING-TOP: 0in; BORDER-BOTTOM: windowtext 1pt solid; HEIGHT: 12.75pt; mso-border-top-alt: solid windowtext .5pt; mso-border-bottom-alt: solid windowtext .5pt; mso-border-right-alt: solid windowtext .5pt" vAlign=bottom noWrap width=75>

Unit Price<o></o>​

</TD><TD style="BORDER-RIGHT: windowtext 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: windowtext 1pt solid; PADDING-LEFT: 5.4pt; BACKGROUND: silver; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; WIDTH: 48pt; PADDING-TOP: 0in; BORDER-BOTTOM: windowtext 1pt solid; HEIGHT: 12.75pt; mso-border-top-alt: solid windowtext .5pt; mso-border-bottom-alt: solid windowtext .5pt; mso-border-right-alt: solid windowtext .5pt" vAlign=bottom noWrap width=64>

Total<o></o>​

</TD></TR><TR style="HEIGHT: 12.75pt; mso-yfti-irow: 1"><TD style="BORDER-RIGHT: windowtext 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: windowtext 1pt solid; WIDTH: 48pt; PADDING-TOP: 0in; BORDER-BOTTOM: windowtext 1pt solid; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent; mso-border-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt" vAlign=bottom noWrap width=64> 0<o></o>
</TD><TD style="BORDER-RIGHT: windowtext 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; BACKGROUND: silver; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; WIDTH: 53pt; PADDING-TOP: 0in; BORDER-BOTTOM: windowtext 1pt solid; HEIGHT: 12.75pt; mso-border-top-alt: solid windowtext .5pt; mso-border-bottom-alt: solid windowtext .5pt; mso-border-right-alt: solid windowtext .5pt" vAlign=bottom noWrap width=71>

8<o></o>​

</TD><TD style="BORDER-RIGHT: windowtext 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; BACKGROUND: silver; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; WIDTH: 28.05pt; PADDING-TOP: 0in; BORDER-BOTTOM: windowtext 1pt solid; HEIGHT: 12.75pt; mso-border-top-alt: solid windowtext .5pt; mso-border-bottom-alt: solid windowtext .5pt; mso-border-right-alt: solid windowtext .5pt" vAlign=bottom noWrap width=37>

<o></o>​

</TD><TD style="BORDER-RIGHT: windowtext 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; BACKGROUND: silver; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; WIDTH: 206pt; PADDING-TOP: 0in; BORDER-BOTTOM: windowtext 1pt solid; HEIGHT: 12.75pt; mso-border-top-alt: solid windowtext .5pt; mso-border-bottom-alt: solid windowtext .5pt; mso-border-right-alt: solid windowtext .5pt" vAlign=bottom noWrap width=275> <o></o>
</TD><TD style="BORDER-RIGHT: windowtext 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; BACKGROUND: silver; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; WIDTH: 56pt; PADDING-TOP: 0in; BORDER-BOTTOM: windowtext 1pt solid; HEIGHT: 12.75pt; mso-border-top-alt: solid windowtext .5pt; mso-border-bottom-alt: solid windowtext .5pt; mso-border-right-alt: solid windowtext .5pt" vAlign=bottom noWrap width=75>

10<o></o>​

</TD><TD style="BORDER-RIGHT: windowtext 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; BACKGROUND: silver; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; WIDTH: 48pt; PADDING-TOP: 0in; BORDER-BOTTOM: windowtext 1pt solid; HEIGHT: 12.75pt; mso-border-top-alt: solid windowtext .5pt; mso-border-bottom-alt: solid windowtext .5pt; mso-border-right-alt: solid windowtext .5pt" vAlign=bottom noWrap width=64>

80<o></o>​

</TD></TR><TR style="HEIGHT: 12.75pt; mso-yfti-irow: 2"><TD style="BORDER-RIGHT: windowtext 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: windowtext 1pt solid; WIDTH: 48pt; PADDING-TOP: 0in; BORDER-BOTTOM: windowtext 1pt solid; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent; mso-border-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt" vAlign=bottom noWrap width=64> 300<o></o>
</TD><TD style="BORDER-RIGHT: windowtext 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; BACKGROUND: silver; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; WIDTH: 53pt; PADDING-TOP: 0in; BORDER-BOTTOM: windowtext 1pt solid; HEIGHT: 12.75pt; mso-border-top-alt: solid windowtext .5pt; mso-border-bottom-alt: solid windowtext .5pt; mso-border-right-alt: solid windowtext .5pt" vAlign=bottom noWrap width=71>

2<o></o>​

</TD><TD style="BORDER-RIGHT: windowtext 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; BACKGROUND: silver; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; WIDTH: 28.05pt; PADDING-TOP: 0in; BORDER-BOTTOM: windowtext 1pt solid; HEIGHT: 12.75pt; mso-border-top-alt: solid windowtext .5pt; mso-border-bottom-alt: solid windowtext .5pt; mso-border-right-alt: solid windowtext .5pt" vAlign=bottom noWrap width=37>

x <o></o>​

</TD><TD style="BORDER-RIGHT: windowtext 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; BACKGROUND: silver; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; WIDTH: 206pt; PADDING-TOP: 0in; BORDER-BOTTOM: windowtext 1pt solid; HEIGHT: 12.75pt; mso-border-top-alt: solid windowtext .5pt; mso-border-bottom-alt: solid windowtext .5pt; mso-border-right-alt: solid windowtext .5pt" vAlign=bottom noWrap width=275> <o></o>
</TD><TD style="BORDER-RIGHT: windowtext 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; BACKGROUND: silver; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; WIDTH: 56pt; PADDING-TOP: 0in; BORDER-BOTTOM: windowtext 1pt solid; HEIGHT: 12.75pt; mso-border-top-alt: solid windowtext .5pt; mso-border-bottom-alt: solid windowtext .5pt; mso-border-right-alt: solid windowtext .5pt" vAlign=bottom noWrap width=75>

150<o></o>​

</TD><TD style="BORDER-RIGHT: windowtext 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; BACKGROUND: silver; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; WIDTH: 48pt; PADDING-TOP: 0in; BORDER-BOTTOM: windowtext 1pt solid; HEIGHT: 12.75pt; mso-border-top-alt: solid windowtext .5pt; mso-border-bottom-alt: solid windowtext .5pt; mso-border-right-alt: solid windowtext .5pt" vAlign=bottom noWrap width=64>

300<o></o>​

</TD></TR><TR style="HEIGHT: 12.75pt; mso-yfti-irow: 3"><TD style="BORDER-RIGHT: windowtext 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: windowtext 1pt solid; WIDTH: 48pt; PADDING-TOP: 0in; BORDER-BOTTOM: windowtext 1pt solid; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent; mso-border-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt" vAlign=bottom noWrap width=64>300<o></o>
</TD><TD style="BORDER-RIGHT: windowtext 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; BACKGROUND: silver; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; WIDTH: 53pt; PADDING-TOP: 0in; BORDER-BOTTOM: windowtext 1pt solid; HEIGHT: 12.75pt; mso-border-top-alt: solid windowtext .5pt; mso-border-bottom-alt: solid windowtext .5pt; mso-border-right-alt: solid windowtext .5pt" vAlign=bottom noWrap width=71><o> </o>
</TD><TD style="BORDER-RIGHT: windowtext 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; BACKGROUND: silver; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; WIDTH: 28.05pt; PADDING-TOP: 0in; BORDER-BOTTOM: windowtext 1pt solid; HEIGHT: 12.75pt; mso-border-top-alt: solid windowtext .5pt; mso-border-bottom-alt: solid windowtext .5pt; mso-border-right-alt: solid windowtext .5pt" vAlign=bottom noWrap width=37><o> </o>
</TD><TD style="BORDER-RIGHT: windowtext 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; BACKGROUND: silver; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; WIDTH: 206pt; PADDING-TOP: 0in; BORDER-BOTTOM: windowtext 1pt solid; HEIGHT: 12.75pt; mso-border-top-alt: solid windowtext .5pt; mso-border-bottom-alt: solid windowtext .5pt; mso-border-right-alt: solid windowtext .5pt" vAlign=bottom noWrap width=275><o> </o>
</TD><TD style="BORDER-RIGHT: windowtext 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; BACKGROUND: silver; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; WIDTH: 56pt; PADDING-TOP: 0in; BORDER-BOTTOM: windowtext 1pt solid; HEIGHT: 12.75pt; mso-border-top-alt: solid windowtext .5pt; mso-border-bottom-alt: solid windowtext .5pt; mso-border-right-alt: solid windowtext .5pt" vAlign=bottom noWrap width=75>Subtotal<o></o>
</TD><TD style="BORDER-RIGHT: windowtext 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; BACKGROUND: silver; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; WIDTH: 48pt; PADDING-TOP: 0in; BORDER-BOTTOM: windowtext 1pt solid; HEIGHT: 12.75pt; mso-border-top-alt: solid windowtext .5pt; mso-border-bottom-alt: solid windowtext .5pt; mso-border-right-alt: solid windowtext .5pt" vAlign=bottom noWrap width=64>

380<o></o>​

</TD></TR><TR style="HEIGHT: 12.75pt; mso-yfti-irow: 4"><TD style="BORDER-RIGHT: windowtext 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: windowtext 1pt solid; WIDTH: 48pt; PADDING-TOP: 0in; BORDER-BOTTOM: windowtext 1pt solid; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent; mso-border-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt" vAlign=bottom noWrap width=64><o> </o>
</TD><TD style="BORDER-RIGHT: windowtext 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; BACKGROUND: silver; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; WIDTH: 53pt; PADDING-TOP: 0in; BORDER-BOTTOM: windowtext 1pt solid; HEIGHT: 12.75pt; mso-border-top-alt: solid windowtext .5pt; mso-border-bottom-alt: solid windowtext .5pt; mso-border-right-alt: solid windowtext .5pt" vAlign=bottom noWrap width=71><o> </o>
</TD><TD style="BORDER-RIGHT: windowtext 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; BACKGROUND: silver; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; WIDTH: 28.05pt; PADDING-TOP: 0in; BORDER-BOTTOM: windowtext 1pt solid; HEIGHT: 12.75pt; mso-border-top-alt: solid windowtext .5pt; mso-border-bottom-alt: solid windowtext .5pt; mso-border-right-alt: solid windowtext .5pt" vAlign=bottom noWrap width=37><o> </o>
</TD><TD style="BORDER-RIGHT: windowtext 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; BACKGROUND: silver; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; WIDTH: 206pt; PADDING-TOP: 0in; BORDER-BOTTOM: windowtext 1pt solid; HEIGHT: 12.75pt; mso-border-top-alt: solid windowtext .5pt; mso-border-bottom-alt: solid windowtext .5pt; mso-border-right-alt: solid windowtext .5pt" vAlign=bottom noWrap width=275><o> </o>
</TD><TD style="BORDER-RIGHT: windowtext 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; BACKGROUND: silver; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; WIDTH: 56pt; PADDING-TOP: 0in; BORDER-BOTTOM: windowtext 1pt solid; HEIGHT: 12.75pt; mso-border-top-alt: solid windowtext .5pt; mso-border-bottom-alt: solid windowtext .5pt; mso-border-right-alt: solid windowtext .5pt" vAlign=bottom noWrap width=75>Sales Tax<o></o>
</TD><TD style="BORDER-RIGHT: windowtext 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; BACKGROUND: silver; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; WIDTH: 48pt; PADDING-TOP: 0in; BORDER-BOTTOM: windowtext 1pt solid; HEIGHT: 12.75pt; mso-border-top-alt: solid windowtext .5pt; mso-border-bottom-alt: solid windowtext .5pt; mso-border-right-alt: solid windowtext .5pt" vAlign=bottom noWrap width=64> 24.00<o></o>
</TD></TR><TR style="HEIGHT: 12.75pt; mso-yfti-irow: 5"><TD style="BORDER-RIGHT: windowtext 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: windowtext 1pt solid; WIDTH: 48pt; PADDING-TOP: 0in; BORDER-BOTTOM: windowtext 1pt solid; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent; mso-border-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt" vAlign=bottom noWrap width=64><o> </o>
</TD><TD style="BORDER-RIGHT: windowtext 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; BACKGROUND: silver; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; WIDTH: 53pt; PADDING-TOP: 0in; BORDER-BOTTOM: windowtext 1pt solid; HEIGHT: 12.75pt; mso-border-top-alt: solid windowtext .5pt; mso-border-bottom-alt: solid windowtext .5pt; mso-border-right-alt: solid windowtext .5pt" vAlign=bottom noWrap width=71><o> </o>
</TD><TD style="BORDER-RIGHT: windowtext 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; BACKGROUND: silver; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; WIDTH: 28.05pt; PADDING-TOP: 0in; BORDER-BOTTOM: windowtext 1pt solid; HEIGHT: 12.75pt; mso-border-top-alt: solid windowtext .5pt; mso-border-bottom-alt: solid windowtext .5pt; mso-border-right-alt: solid windowtext .5pt" vAlign=bottom noWrap width=37><o> </o>
</TD><TD style="BORDER-RIGHT: windowtext 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; BACKGROUND: silver; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; WIDTH: 206pt; PADDING-TOP: 0in; BORDER-BOTTOM: windowtext 1pt solid; HEIGHT: 12.75pt; mso-border-top-alt: solid windowtext .5pt; mso-border-bottom-alt: solid windowtext .5pt; mso-border-right-alt: solid windowtext .5pt" vAlign=bottom noWrap width=275>

Shipping/<o></o>​

</TD><TD style="BORDER-RIGHT: windowtext 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; BACKGROUND: silver; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; WIDTH: 56pt; PADDING-TOP: 0in; BORDER-BOTTOM: windowtext 1pt solid; HEIGHT: 12.75pt; mso-border-top-alt: solid windowtext .5pt; mso-border-bottom-alt: solid windowtext .5pt; mso-border-right-alt: solid windowtext .5pt" vAlign=bottom noWrap width=75>Handling<o></o>
</TD><TD style="BORDER-RIGHT: windowtext 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; BACKGROUND: silver; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; WIDTH: 48pt; PADDING-TOP: 0in; BORDER-BOTTOM: windowtext 1pt solid; HEIGHT: 12.75pt; mso-border-top-alt: solid windowtext .5pt; mso-border-bottom-alt: solid windowtext .5pt; mso-border-right-alt: solid windowtext .5pt" vAlign=bottom noWrap width=64> <o></o>
</TD></TR><TR style="HEIGHT: 12.75pt; mso-yfti-irow: 6; mso-yfti-lastrow: yes"><TD style="BORDER-RIGHT: windowtext 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; PADDING-BOTTOM: 0in; BORDER-LEFT: windowtext 1pt solid; WIDTH: 48pt; PADDING-TOP: 0in; BORDER-BOTTOM: windowtext 1pt solid; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent; mso-border-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt" vAlign=bottom noWrap width=64><o> </o>
</TD><TD style="BORDER-RIGHT: windowtext 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; BACKGROUND: silver; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; WIDTH: 53pt; PADDING-TOP: 0in; BORDER-BOTTOM: windowtext 1pt solid; HEIGHT: 12.75pt; mso-border-top-alt: solid windowtext .5pt; mso-border-bottom-alt: solid windowtext .5pt; mso-border-right-alt: solid windowtext .5pt" vAlign=bottom noWrap width=71><o> </o>
</TD><TD style="BORDER-RIGHT: windowtext 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; BACKGROUND: silver; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; WIDTH: 28.05pt; PADDING-TOP: 0in; BORDER-BOTTOM: windowtext 1pt solid; HEIGHT: 12.75pt; mso-border-top-alt: solid windowtext .5pt; mso-border-bottom-alt: solid windowtext .5pt; mso-border-right-alt: solid windowtext .5pt" vAlign=bottom noWrap width=37><o> </o>
</TD><TD style="BORDER-RIGHT: windowtext 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; BACKGROUND: silver; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; WIDTH: 206pt; PADDING-TOP: 0in; BORDER-BOTTOM: windowtext 1pt solid; HEIGHT: 12.75pt; mso-border-top-alt: solid windowtext .5pt; mso-border-bottom-alt: solid windowtext .5pt; mso-border-right-alt: solid windowtext .5pt" vAlign=bottom noWrap width=275><o> </o>
</TD><TD style="BORDER-RIGHT: windowtext 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; BACKGROUND: silver; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; WIDTH: 56pt; PADDING-TOP: 0in; BORDER-BOTTOM: windowtext 1pt solid; HEIGHT: 12.75pt; mso-border-top-alt: solid windowtext .5pt; mso-border-bottom-alt: solid windowtext .5pt; mso-border-right-alt: solid windowtext .5pt" vAlign=bottom noWrap width=75>Total<o></o>
</TD><TD style="BORDER-RIGHT: windowtext 1pt solid; PADDING-RIGHT: 5.4pt; BORDER-TOP: #ece9d8; PADDING-LEFT: 5.4pt; BACKGROUND: silver; PADDING-BOTTOM: 0in; BORDER-LEFT: #ece9d8; WIDTH: 48pt; PADDING-TOP: 0in; BORDER-BOTTOM: windowtext 1pt solid; HEIGHT: 12.75pt; mso-border-top-alt: solid windowtext .5pt; mso-border-bottom-alt: solid windowtext .5pt; mso-border-right-alt: solid windowtext .5pt" vAlign=bottom noWrap width=64>

404<o></o>​

</TD></TR></TBODY></TABLE>
<o> </o>
I have tried a number of different ways, the last thing I tried was hiding a cell that contained the sum of the taxable items, the idea was to only add to this field when the ‘tax’ cell contained a ‘x’: if(c3=x,product(c2,e2),**); this is my problem; excel will not accept the formula.
<o> </o>
Bill
<o> </o>

 

[Weaver]

If you're testing for strings (which x is), you need to include it within double quotes

so,

=IF(C3="x"....

 

[theozz]

Hi ! Here Suggest to you.


<table style="border-collapse: separate;" colspan="2" border="7" cellspacing="0"><tbody bgcolor="#ffffff"><tr height="30"><td colspan="2"> Nice Question Thanks.
DataSheet= Sheet1</td></tr><tr><td align="right" width="30"><table style="table-layout: fixed;" rowspan="17" cellspacing="1" width="30"><tbody bgcolor="#ffffff"><tr height="18"><td>
</td></tr><tr height="18"><td align="right" bgcolor="#dcdcdc">1 </td></tr><tr height="18"><td align="right" bgcolor="#dcdcdc">2 </td></tr><tr height="18"><td align="right" bgcolor="#dcdcdc">3 </td></tr><tr height="18"><td align="right" bgcolor="#dcdcdc">4 </td></tr><tr height="18"><td align="right" bgcolor="#dcdcdc">5 </td></tr><tr height="18"><td align="right" bgcolor="#dcdcdc">6 </td></tr><tr height="18"><td align="right" bgcolor="#dcdcdc">7 </td></tr><tr height="18"><td align="right" bgcolor="#dcdcdc">8 </td></tr><tr height="18"><td align="right" bgcolor="#dcdcdc">9 </td></tr><tr height="18"><td align="right" bgcolor="#dcdcdc">10 </td></tr><tr height="18"><td align="right" bgcolor="#dcdcdc">11 </td></tr><tr height="18"><td align="right" bgcolor="#dcdcdc">12 </td></tr><tr height="18"><td align="right" bgcolor="#dcdcdc">13 </td></tr><tr height="18"><td align="right" bgcolor="#dcdcdc">14 </td></tr><tr height="18"><td align="right" bgcolor="#dcdcdc">15 </td></tr><tr height="18"><td align="right" bgcolor="#dcdcdc">16 </td></tr></tbody></table></td><td width="624"><table colspan="8" rowspan="8" style="table-layout: fixed;" bgcolor="#939393" border="0" cellspacing="1" width="624"><col width="123"><col width="81"><col width="39"><col width="111"><col width="96"><col width="81"><col width="52"><col width="37"><tbody bgcolor="#ffffff"><tr height="18"><td style="font-family: verdana;" align="center" bgcolor="#dcdcdc">A</td><td style="font-family: verdana;" align="center" bgcolor="#dcdcdc">B</td><td style="font-family: verdana;" align="center" bgcolor="#dcdcdc">C</td><td style="font-family: verdana;" align="center" bgcolor="#dcdcdc">D</td><td style="font-family: verdana;" align="center" bgcolor="#dcdcdc">E</td><td style="font-family: verdana;" align="center" bgcolor="#dcdcdc">F</td><td style="font-family: verdana;" align="center" bgcolor="#dcdcdc">G</td><td style="font-family: verdana;" align="center" bgcolor="#dcdcdc">H</td></tr><tr height="18"><td align="center" bgcolor="#ffffff" width="123">Hiddenfield</td><td align="center" bgcolor="#ffff00" width="81">Quantity</td><td align="center" bgcolor="#ffff00" width="39">Tax</td><td align="center" bgcolor="#ffff00" width="111">Description</td><td align="center" bgcolor="#ffff00" width="96">UnitPrice</td><td align="center" bgcolor="#ffff00" width="81">Total</td><td bgcolor="#ffffff" width="52"> </td><td bgcolor="#ffffff" width="37"> </td></tr><tr height="18"><td align="right" bgcolor="#ffffff" width="123">0</td><td align="center" bgcolor="#ffff00" width="81">8</td><td bgcolor="#ffff00" width="39"> </td><td bgcolor="#ffff00" width="111"> </td><td align="right" bgcolor="#ffff00" width="96">10</td><td align="right" bgcolor="#ffff00" width="81">80</td><td bgcolor="#ffffff" width="52"> </td><td bgcolor="#ffffff" width="37"> </td></tr><tr height="18"><td align="right" bgcolor="#ffffff" width="123">300</td><td align="center" bgcolor="#ffff00" width="81">2</td><td align="center" bgcolor="#ffff00" width="39">x</td><td bgcolor="#ffff00" width="111"> </td><td align="right" bgcolor="#ffff00" width="96">150</td><td align="right" bgcolor="#ffff00" width="81">300</td><td bgcolor="#ffffff" width="52"> </td><td bgcolor="#ffffff" width="37"> </td></tr><tr height="18"><td align="right" bgcolor="#ffffff" width="123">300</td><td bgcolor="#ffff00" width="81"> </td><td bgcolor="#ffff00" width="39"> </td><td bgcolor="#ffff00" width="111"> </td><td bgcolor="#ffff00" width="96">Subtotal</td><td align="right" bgcolor="#ffff00" width="81">380</td><td bgcolor="#ffffff" width="52">or'</td><td bgcolor="#ffffff" width="37"> </td></tr><tr height="18"><td bgcolor="#ffffff" width="123"> </td><td bgcolor="#ffff00" width="81"> </td><td bgcolor="#ffff00" width="39"> </td><td bgcolor="#ffff00" width="111"> </td><td bgcolor="#ffff00" width="96">SalesTax</td><td align="right" bgcolor="#ffff00" width="81">24</td><td align="right" bgcolor="#ffcc00" width="52">24</td><td bgcolor="#cc99ff" width="37">x</td></tr><tr height="18"><td bgcolor="#ffffff" width="123"> </td><td bgcolor="#ffff00" width="81"> </td><td bgcolor="#ffff00" width="39"> </td><td align="right" bgcolor="#ffff00" width="111">Shipping/</td><td bgcolor="#ffff00" width="96">Handling</td><td bgcolor="#ffff00" width="81"> </td><td bgcolor="#ffffff" width="52"> </td><td bgcolor="#ffffff" width="37"> </td></tr><tr height="18"><td bgcolor="#ffffff" width="123"> </td><td bgcolor="#ffff00" width="81"> </td><td bgcolor="#ffff00" width="39"> </td><td bgcolor="#ffff00" width="111"> </td><td bgcolor="#ffff00" width="96">Total</td><td align="right" bgcolor="#ffff00" width="81">404</td><td bgcolor="#ffffff" width="52"> </td><td bgcolor="#ffffff" width="37"> </td></tr><tr height="18"><td bgcolor="#ffffff" width="123"> </td><td bgcolor="#ffffff" width="81"> </td><td bgcolor="#ffffff" width="39"> </td><td bgcolor="#ffffff" width="111"> </td><td bgcolor="#ffffff" width="96"> </td><td bgcolor="#ffffff" width="81"> </td><td bgcolor="#ffffff" width="52"> </td><td bgcolor="#ffffff" width="37"> </td></tr></tbody></table><table colspan="8" rowspan="8" style="table-layout: fixed;" bgcolor="#939393" border="0" cellspacing="1" width="624"><col width="123"><col width="81"><col width="39"><col width="111"><col width="96"><col width="81"><col width="52"><col width="37"><tbody bgcolor="#ffffff"><tr height="18"><td align="center" bgcolor="#ffffff" width="123">Hiddenfield</td><td align="center" bgcolor="#ffff00" width="81">Quantity</td><td align="center" bgcolor="#ffff00" width="39">Tax</td><td align="center" bgcolor="#ffff00" width="111">Description</td><td align="center" bgcolor="#ffff00" width="96">UnitPrice</td><td align="center" bgcolor="#ffff00" width="81">Total</td><td bgcolor="#ffffff" width="52"> </td><td bgcolor="#ffffff" width="37"> </td></tr><tr height="18"><td align="right" bgcolor="#ffffff" width="123">0</td><td align="center" bgcolor="#ffff00" width="81">8</td><td bgcolor="#ffff00" width="39"> </td><td bgcolor="#ffff00" width="111"> </td><td align="right" bgcolor="#ffff00" width="96">10</td><td align="right" bgcolor="#ffff00" width="81">80</td><td bgcolor="#ffffff" width="52"> </td><td bgcolor="#ffffff" width="37"> </td></tr><tr height="18"><td bgcolor="#ffffff" width="123"> </td><td align="center" bgcolor="#ffff99" width="81">0</td><td bgcolor="#ffff99" width="39"> </td><td bgcolor="#ffff99" width="111"> </td><td align="right" bgcolor="#ffff99" width="96">10</td><td align="right" bgcolor="#ffff99" width="81"> </td><td colspan="2" align="center" bgcolor="#ffffff" width="90">like this…</td></tr><tr height="18"><td align="right" bgcolor="#ffffff" width="123">300</td><td align="center" bgcolor="#ffff00" width="81">2</td><td align="center" bgcolor="#ffff00" width="39">x</td><td bgcolor="#ffff00" width="111"> </td><td align="right" bgcolor="#ffff00" width="96">150</td><td align="right" bgcolor="#ffff00" width="81">300</td><td bgcolor="#ffffff" width="52"> </td><td bgcolor="#ffffff" width="37"> </td></tr><tr height="18"><td align="right" bgcolor="#ffffff" width="123">300</td><td bgcolor="#ffff00" width="81"> </td><td bgcolor="#ffff00" width="39"> </td><td bgcolor="#ffff00" width="111"> </td><td bgcolor="#ffff00" width="96">Subtotal</td><td align="right" bgcolor="#ffff00" width="81">380</td><td bgcolor="#ffffff" width="52"> </td><td bgcolor="#ffffff" width="37"> </td></tr><tr height="18"><td bgcolor="#ffffff" width="123"> </td><td bgcolor="#ffff00" width="81"> </td><td bgcolor="#ffff00" width="39"> </td><td bgcolor="#ffff00" width="111"> </td><td bgcolor="#ffff00" width="96">SalesTax</td><td align="right" bgcolor="#ffff00" width="81">24</td><td bgcolor="#ffffff" width="52"> </td><td bgcolor="#ffffff" width="37"> </td></tr><tr height="18"><td bgcolor="#ffffff" width="123"> </td><td bgcolor="#ffff00" width="81"> </td><td bgcolor="#ffff00" width="39"> </td><td align="right" bgcolor="#ffff00" width="111">Shipping/</td><td bgcolor="#ffff00" width="96">Handling</td><td bgcolor="#ffff00" width="81"> </td><td bgcolor="#ffffff" width="52"> </td><td bgcolor="#ffffff" width="37"> </td></tr><tr height="18"><td bgcolor="#ffffff" width="123"> </td><td bgcolor="#ffff00" width="81"> </td><td bgcolor="#ffff00" width="39"> </td><td bgcolor="#ffff00" width="111"> </td><td bgcolor="#ffff00" width="96">Total</td><td align="right" bgcolor="#ffff00" width="81">404</td><td bgcolor="#ffffff" width="52"> </td><td bgcolor="#ffffff" width="37"> </td></tr></tbody></table></td></tr></tbody></table>
<colspan=5 width="800" rowspan="11" height="198"></colspan=5><table style="border-collapse: separate;" border="6" cellspacing="0"><tbody><tr height="24"><td colspan="5" align="center">Used Formula ...(With Running MicrosoftExcel Ver 2003)</td></tr><tr height="24"><td align="center" bgcolor="#d3d3d3" width="4%">No</td><td align="center" bgcolor="#d3d3d3" width="9%">Addr'</td><td align="center" bgcolor="#d3d3d3" width="65%"> If use below Formula, You'll Get Result as Right</td><td align="center" bgcolor="#d3d3d3" width="15%">Result</td><td align="center" bgcolor="#d3d3d3">Formula's</td></tr><tr height="20"><td align="center">1</td><td align="center" bgcolor="#ffff00">F4</td><td bgcolor="#ffff00">=SUM(F2:F3)</td><td align="right">380</td><td align="right"><form name="PrNames1"><input onclick='window.clipboardData.setData("Text","=SUM(F2:F3)");' value="Do Copy" name="MyNames1" type="button"></form></td></tr><tr height="20"><td align="center">2</td><td align="center" bgcolor="#ffff00">F5</td><td bgcolor="#ffff00">=SUMPRODUCT(--(C2:C3="x"),F2:F3*8%)</td><td align="right">24</td><td align="right"><form name="PrNames2"><input onclick='window.clipboardData.setData("Text","=SUMPRODUCT(--(C2:C3=\"x\"),F2:F3*8%)");' value="Do Copy" name="MyNames2" type="button"></form></td></tr><tr height="20"><td align="center">3</td><td align="center" bgcolor="#ffcc00">G5</td><td bgcolor="#ffcc00">=SUMPRODUCT(--(C2:C3=H5),F2:F3*8%)</td><td align="right">24</td><td align="right"><form name="PrNames3"><input onclick='window.clipboardData.setData("Text","=SUMPRODUCT(--(C2:C3=H5),F2:F3*8%)");' value="Do Copy" name="MyNames3" type="button"></form></td></tr><tr height="20"><td align="center">4</td><td align="center" bgcolor="#ffff00">F7</td><td bgcolor="#ffff00">=SUM(F4:F5)</td><td align="right">404</td><td align="right"><form name="PrNames4"><input onclick='window.clipboardData.setData("Text","=SUM(F4:F5)");' value="Do Copy" name="MyNames4" type="button"></form></td></tr><tr height="20"><td align="center">5</td><td align="center" bgcolor="#ffff00">F10</td><td bgcolor="#ffff00">=IF(B10=0,"",B10*E10)</td><td align="right">80</td><td align="right"><form name="PrNames5"><input onclick='window.clipboardData.setData("Text","=IF(B10=0,\"\",B10*E10)");' value="Do Copy" name="MyNames5" type="button"></form></td></tr><tr height="20"><td align="center">6</td><td align="center" bgcolor="#ffff99">F11</td><td bgcolor="#ffff99">=IF(B11=0,"",B11*E11)</td><td align="right"> </td><td align="right"><form name="PrNames6"><input onclick='window.clipboardData.setData("Text","=IF(B11=0,\"\",B11*E11)");' value="Do Copy" name="MyNames6" type="button"></form></td></tr><tr height="20"><td align="center">7</td><td align="center" bgcolor="#ffff00">F12</td><td bgcolor="#ffff00">=IF(B12=0,"",B12*E12)</td><td align="right">300</td><td align="right"><form name="PrNames7"><input onclick='window.clipboardData.setData("Text","=IF(B12=0,\"\",B12*E12)");' value="Do Copy" name="MyNames7" type="button"></form></td></tr><tr height="20"><td align="center">8</td><td align="center" bgcolor="#ffff00">F13</td><td bgcolor="#ffff00">=SUM(F10:F12)</td><td align="right">380</td><td align="right"><form name="PrNames8"><input onclick='window.clipboardData.setData("Text","=SUM(F10:F12)");' value="Do Copy" name="MyNames8" type="button"></form></td></tr><tr height="20"><td align="center">9</td><td align="center" bgcolor="#ffff00">F14</td><td bgcolor="#ffff00">=SUMPRODUCT((C10:C12="x")*8%,F10:F12)</td><td align="right">24</td><td align="right"><form name="PrNames9"><input onclick='window.clipboardData.setData("Text","=SUMPRODUCT((C10:C12=\"x\")*8%,F10:F12)");' value="Do Copy" name="MyNames9" type="button"></form></td></tr><tr height="20"><td align="center">10</td><td align="center" bgcolor="#ffff00">F16</td><td bgcolor="#ffff00">=SUM(F13:F14)</td><td align="right">404</td><td align="right"><form name="PrNames10"><input onclick='window.clipboardData.setData("Text","=SUM(F13:F14)");' value="Do Copy" name="MyNames10" type="button"></form></td></tr><tr height="24"><td colspan="5">.</td></tr></tbody></table>

 

[lenze]

Hi and welcome to the board!!!
Try this for your sales tax total

=SUMIF($C$2:$C$4),"x",$F$2:$F4)*.08

lenze

 

[theozz]

Simple and Cute formula thanks knowledge

 

[bill85310]

WOW
I Can't thank all of you enough for the help!!!
I will try your solutions tonight, I am sure I will be able finish my invoice now.

thx again

Bill