I have a formula but I can see to get it. shirt 13 at 29.95, pants 22 at 31.99, shoes 18 at 74.99, dress 16 at 69.99, then I have a discount for 15% and an additinal 10 discoun. Then I have the sales tax for 8.25% and I get see to ge the formula for these. Please help me I really appreciated.
You are going to have to refer to cells in the formula.
http://office.microsoft.com/en-us/excel/HP052001271033.aspx
On the Excel sheet, I would label column 1 Item, column 2 Quantity, column 3 cost each, column 4 total cost.
Row 1 will be shirt, row 2 will be pants, row 3 will be shoes, row 4 will be dress, row 5 will be subtotal, row 6 will be 15% discount, row 7 will be additional 10% discount, row 8 will be subtotal, row 9 will be plus 8.25% sales tax, and row 10 will be Grand total. I have a feeling this is NOT what you are looking for but if it is I can go further.
yes that how I did it but I have not been ebla to get the correct formula. evry time I try to get it it says value error.
To calculate the total cost for each item, you can multiply the quantity by the price:
Shirt: 13 * $29.95 = $389.35
Pants: 22 * $31.99 = $703.78
Shoes: 18 * $74.99 = $1,349.82
Dress: 16 * $69.99 = $1,119.84
To calculate the discount, first apply the 15% discount and then the additional 10% discount on the discounted price:
Discounted price with 15% off = Original price * (1 - 0.15)
Discounted price with 10% off = Discounted price with 15% off * (1 - 0.10)
For example, let's calculate the discounted price for the shirt:
Discounted price with 15% off = $389.35 * (1 - 0.15) = $330.95
Discounted price with 10% off = $330.95 * (1 - 0.10) = $297.85
Now, to calculate the sales tax, you can multiply the total discounted price by the sales tax rate:
Total discounted price = (Discounted price with 10% off for each item) + (Discounted price with 10% off for each item) + (Discounted price with 10% off for each item)+ (Discounted price with 10% off for each item)
Sales tax = Total discounted price * 0.0825
Finally, to calculate the final cost, add the sales tax to the total discounted price:
Final cost = Total discounted price + Sales tax
I hope this helps! Let me know if you have any further questions.