Outdoorsman80
Board Regular
- Joined
- Oct 4, 2014
- Messages
- 61
- Office Version
- 365
- Platform
- Windows
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:
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?
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:
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?