# 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. ### Mathematics

3. Glenn has 4 pants and 3 shirts. How many different pairs of a pants and shirts can he wear? 4. A mall has five gates. How many can one enter and exit the mall?

4. ### math

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

1. ### 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!!!

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 pair of pants costs twice as much as a shirt. The total cost of 1 1 pair of pants and 1 1 shirt is \$18 \$18 . If s represents the cost of 1 1 shirt, which equation could you use to find the cost of 1 1 shirt?

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. ### 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?

2. ### MATH

Bobby bought 3 T-shirts at the mall and a pair of pants for \$16 at the clothing store. His total was \$28. How much was each shirt? *