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

  3. 8th grade math

    juliet bought a pair of pants that normally cost $40 for a sale price of $24. what was the percent discount on the pants?

  4. Math

    Bought 3 shirts & 2 pair pants for $85 and my friend bought 2 shirts & 5 pants for $130, and the shirts are the same price, what is the price of each shirt?

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