Calculating sales tax in formula

[Outdoorsman80]

I think I'm too tired and am over thinking this one.

I have a chart that I'm trying to calculate the total cost for x amount of products at a price before tax and need to add in that tax for a total cost.

For example:

Chart.xlsx
	A	B	C	D
42	Totals	Bags	9	18
43		Lbs.	440	879
44	$ 24.16	Cost	$ 224.10
Chart

Cell Formulas
Range	Formula
C42:D42	D42	=SUM(D2,D7,D12,D17,D22,D27,D32,D37)/50*2
C43:D43	D43	=SUM(D2,D7,D12,D17,D22,D27,D32,D37)*2
C44	C44	=(C42*A$44)+(A$44*C42*5.5%)

You can see in C44, the formula is not coming out right, it should equal $229.39. I've tried different formulas, etc but I just can't make Excel come out right... what am I doing wrong?

 

[Outdoorsman80]

Can you give me a better hint than that? Excel is not liking turning

=SUM(C2,C7,C12,C17,C22,C27,C32,C37)/50*2

to

=ROUNDUP(C2,C7,C12,C17,C22,C27,C32,C37)/50*2

 

[Fluff]

How about

=roundup(SUM(C2,C7,C12,C17,C22,C27,C32,C37)/50*2,0)