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?

 

[Peter_SSs]

Check in File -> Options -> Formulas -> Calculation options that calculation hasn't been taken off Automatic

 

[Outdoorsman80]

It's set to auto, even exiting the document and going back it does not show correct answer.

 

[Fluff]

What exactly is the value in C42, it's probably 8 point something, rather than 9

 

[Outdoorsman80]

If I'm doing my math right for the tax, product is $24.16, tax is 5.5%, so 24.16*.055=$1.32. $1.32+24.16=25.48. 25.48*9=$229.39. Excel shows $224.10.

 

[Fluff]

That does not answer my question.

 

[Outdoorsman80]

I'm sorry- I misread, it is 8.79. Looks like that's why it's doing it then. How do I fix that? I formatted that row to no decimals as they are bags, you can't have 8.79 bags.

 

[Fluff]

You are dividing by 50, which is where the decimals come in. Try wrapping your formula in the Round function.

 

[Outdoorsman80]

I don't see how I can do that with that forumula.

It's taking Pounds per week to feed an animal, each week has a decimal, it needs to be precise. =SUM(C2,C7,C12,C17,C22,C27,C32,C37)/50*2. Each C cell has something like 2.4, 5.5, 5.7, etc.
So it adds that up over 8 weeks, divides it by 50 as the feed bags are 50lbs. The formumla is telling me how many bags I need and being told 8.79 means it's really 9.

 

[Fluff]

In that case you can use roundup, rather than round.