Page 1 of 2 12 LastLast
Results 1 to 10 of 14

Thread: Excel Formula?

  1. #1
    FLAC muldrick's Avatar
    Join Date
    Jun 2004
    Location
    South-Central PA
    Posts
    1,241

    Excel Formula?

    Anybody good with Excel?
    I have column "D" that shows (a list) of prices, how do I create a formula so that column "E" will show the total of each price in column "D", plus 11%?

    Example:
    $12.00+11%=$13.32


    AtmosUSA.biz, E-Cig Mods
    "A great smoking alternative"

  2. #2
    FLAC migel628's Avatar
    Join Date
    Mar 2004
    Location
    New Windsor, NY
    Posts
    1,114
    Quote Originally Posted by muldrick
    Anybody good with Excel?
    I have column "D" that shows (a list) of prices, how do I create a formula so that column "E" will show the total of each price in column "D", plus 11%?

    Example:
    $12.00+11%=$13.32


    wouldn't you just do =D1*1.11?
    "I'm a dick!"
    "I must seek knowledge and it's bastard son truth" - The State

  3. #3
    I'm sorry, and you are....? frodobaggins's Avatar
    Join Date
    Jan 2003
    Location
    Ruston, LA
    Posts
    8,846
    Quote Originally Posted by muldrick
    Anybody good with Excel?
    I have column "D" that shows (a list) of prices, how do I create a formula so that column "E" will show the total of each price in column "D", plus 11%?

    Example:
    $12.00+11%=$13.32


    Like this ?
    Attached Files Attached Files
    [H]4 Life
    My next generation Front End is right on schedule.
    It will be done sometime in the next generation.
    I'm a lesbian too.
    I am for hire!

  4. #4
    FLAC muldrick's Avatar
    Join Date
    Jun 2004
    Location
    South-Central PA
    Posts
    1,241
    Yes, correct. But do I have to create a formula for each cell?
    AtmosUSA.biz, E-Cig Mods
    "A great smoking alternative"

  5. #5
    I'm sorry, and you are....? frodobaggins's Avatar
    Join Date
    Jan 2003
    Location
    Ruston, LA
    Posts
    8,846
    Quote Originally Posted by muldrick
    Yes, correct. But do I have to create a formula for each cell?
    You just highlight the cells and paste the formula.
    [H]4 Life
    My next generation Front End is right on schedule.
    It will be done sometime in the next generation.
    I'm a lesbian too.
    I am for hire!

  6. #6
    FLAC migel628's Avatar
    Join Date
    Mar 2004
    Location
    New Windsor, NY
    Posts
    1,114
    If you're referring to what I wrote, then all you need to do is copy/paste to the cells below the 1st one & excel should pick up the changes...
    "I'm a dick!"
    "I must seek knowledge and it's bastard son truth" - The State

  7. #7
    Variable Bitrate ENerd's Avatar
    Join Date
    Feb 2005
    Location
    Wichita, KS
    Posts
    230
    Do this!
    Attached Images Attached Images  
    1994 Acura Integra GSR (Bone Stock)
    Alpine CVA-1005
    Alpine DVA-5205
    Dreamcast - MP3, MPEG and Games
    JBL DA1002-90
    10" Soundstream Tarantula T2-10
    Wiring by neema12

  8. #8
    FLAC muldrick's Avatar
    Join Date
    Jun 2004
    Location
    South-Central PA
    Posts
    1,241
    Actually I am wrong, Frodo also added each cell and 11%.
    I need each price in E to equal what column D is plus 11%. (Individually)

    D (+11%) = ................E
    $100.00...................$111.00
    $10.00.....................$11.10
    $38.00.....................$42.18
    $20.00....................$22.20

    etc, etc.
    AtmosUSA.biz, E-Cig Mods
    "A great smoking alternative"

  9. #9
    FLAC muldrick's Avatar
    Join Date
    Jun 2004
    Location
    South-Central PA
    Posts
    1,241
    Oooh man. Got it!...You guys are freaking awesome! You saved me hours of work.
    Thanks!

    EDIT: Now how do I get rid of column D without screwing up column E?
    AtmosUSA.biz, E-Cig Mods
    "A great smoking alternative"

  10. #10
    I'm sorry, and you are....? frodobaggins's Avatar
    Join Date
    Jan 2003
    Location
    Ruston, LA
    Posts
    8,846
    hide it
    [H]4 Life
    My next generation Front End is right on schedule.
    It will be done sometime in the next generation.
    I'm a lesbian too.
    I am for hire!

Page 1 of 2 12 LastLast

Similar Threads

  1. Excel 2000 password recovery
    By wizardPC in forum Off Topic
    Replies: 2
    Last Post: 03-07-2005, 02:48 PM
  2. "Autofilling" Excel sheet from an Access DB
    By pogue1000 in forum Software & Software Development
    Replies: 4
    Last Post: 01-18-2005, 09:49 AM

Bookmarks

Posting Permissions

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