# a formula for excel

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.

1. 👍
2. 👎
3. 👁
1. You are going to have to refer to cells in the formula.

http://office.microsoft.com/en-us/excel/HP052001271033.aspx

1. 👍
2. 👎
👤
bobpursley
2. 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.

1. 👍
2. 👎
3. 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.

1. 👍
2. 👎

## Similar Questions

1. ### math

the cost of making a shirt is half of what the shirt normal sells for. Today, however, the shirt is on a 15% discount from its normal price. What is the current price of the shirt?

2. ### math

The cost of making a shirt is half of what the shirt normally sells for. Today, however, the shirt is on a 15% discount from its normal price. What is the current price of the shirt?

3. ### profit and loss

mr.doshi instead of marking up the cost price by 10% discounted the cost price by 10% and prepared the price tag of a shirt. A discount of 5% is applicable to the list price. because of the mistake the company earned rs. 76 less

4. ### math

Glenn has 4 pants and 3 shirts. How many different pairs of pants and shirts can he wear?

1. ### Statistic

A man has 20 shirts, 7 pairs of pants and 4 pairs of shoes. How many different outfits, consisting of one shirt, one pair of pants, and one pair of shoes, are possible

2. ### Language Arts

Which of these sentences has the most negative connotation? 1. This shirt was a bargain. 2. This shirt was a value. 3. This shirt was cheap. 4. This shirt was economical.

3. ### Math

1. You go shopping with a friend and end up buying a shirt for \$23.90, a pair of pants for \$34.50 and some socks for \$3.65. If sales tax is 7.5%, what is your total sales tax amount for all three items? Can you help me with that?

4. ### MATH

During halftime of a football​game, a sling shot launches​ T-shirts at the crowd. A​ T-shirt is launched from a height of 33 feet with an initial upward velocity of 64 feet per second. The​ T-shirt is caught 48 feet above

1. ### math

Haddon’s favorite clothing store is having a sale. Shirts are 25% off and pants are 15% off. Haddon has \$90 to spend on clothes. If shirts were originally priced at \$15.98 and pants were originally priced at \$25.59, which can he

2. ### Math

Joey has 4 pairs of pants,6 shirts, and 2 pairs of shoes, but only 1 favorite pair of pants, 1 favorite shirt, and 1 pair of shoes. If he randomly selects an outfit to wear, what it the probability that it will be his favorite

3. ### math

A shirt is on sale with a 25 dollar discount. the original price of the shirt was \$25. will Wayne have enough money to buy the shirt if he has \$22? plz help i need the answer right now!!!

4. ### Mathematics

A man 22 shirts, 6 pairs of pants and 5 pairs of shoes. How many different outfits, consisting of one shirt, one pair of pants and one pair of shoes are possible?