Results 1 to 3 of 3

Thread: Excel Help

  1. #1
    New Lounger
    Join Date
    Nov 2012
    Posts
    1
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Excel Help

    I'm not sure how to even explain what I need help with. I was able to figure out a few formulas on my own after NO excel experience but now I'm stuck. I am trying to calculate the total inventory in the little store I work in and have been successful with the non-tax items but now I need help. I have a column where i enter the price of item, the next cell over is the total of items on shelf, and then the next cell I have a formula to multiply the two to give me the total value of those items in the store. I now want to put the price of say....a 6pack of beer. ($6.76) + the crv ($0.30) in one cell, then multiply that by the beer tax. I want to then take the total of that cell and multiply it by the number of 6packs in the whole store. So I guess my question is can I make a formula to manipulate multiple numbers inside a cell, (A + B) x C......AHHHH I'm so confused! Thanks to anyone who can figure out what I mean...
    Last edited by beckyleigh; 2012-11-02 at 19:07.

  2. Subscribe to our Windows Secrets Newsletter - It's Free!

    Get our unique weekly Newsletter with tips and techniques, how to's and critical updates on Windows 7, Windows 8, Windows XP, Firefox, Internet Explorer, Google, etc. Join our 480,000 subscribers!

    Excel 2013: The Missing Manual

    + Get this BONUS — free!

    Get the most of Excel! Learn about new features, basics of creating a new spreadsheet and using the infamous Ribbon in the first chapter of Excel 2013: The Missing Manual - Subscribe and download Chapter 1 for free!

  3. #2
    Super Moderator RetiredGeek's Avatar
    Join Date
    Mar 2004
    Location
    Manning, South Carolina
    Posts
    6,058
    Thanks
    196
    Thanked 766 Times in 700 Posts
    Becky,

    Welcome to the Lounge as a new poster!

    Ok, let's say
    Column A contains the Names of your inventory items, e.g. Beer, Soda, Pretzels, etc.
    Column B contains the Price of the item
    Column C contains Inventory Count
    Column D contains the Total Value (B*C)
    Column E Contains the ({Price {Col B} + CRV {Named Value})*BeerTax {Named Value})* Quanity {Col C})

    So for Row 2 {Row 1 has the headers} the formulas would be:
    Col D: =B2*C2
    Col E: =((B2+CRV)*BeerTax)*C2)
    These two formulas can then be filled down the rows.

    NOTE: You actually need to do the following before entering the formulas above!
    Now somewhere unused on the same sheet or preferablly on a separate sheet do this in 2 adjacent columns:
    1st column type: CRV
    2nd column type: .30
    1st Column (next row) type: BeerTax
    2nd column type: the decimal representing the beer tax, e.g. .15 for 15%

    Click on the cell containing .30 then click up in the name box (it should show the address where the .30 is.
    Type in this box CRV then press the ENTER KEY {don't forget to do this or it will not work!}
    Click in the cell directly below containing the beer tax percent.
    Click in the name box again and type BeerTax then press the ENTER KEY.
    May the Forces of good computing be with you!

    RG

    VBA Rules!

    My Systems: Desktop Specs
    Laptop Specs


  4. #3
    Platinum Lounger
    Join Date
    Dec 2009
    Location
    Earth
    Posts
    3,545
    Thanks
    7
    Thanked 225 Times in 213 Posts
    You don't need the second brackets for the formula in E, plus you have one bracket too many.
    Col E: =(B2+CRV)*BeerTax*C2

    cheers, Paul

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •