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. 👎

Respond to this Question

First Name

Your Response

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?

You can view more similar questions or ask a new question.