Announcement

Collapse
No announcement yet.

Excel Formula?

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • 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
    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

    Comment


    • #3
      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
      [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!

      Comment


      • #4
        Yes, correct. But do I have to create a formula for each cell?
        AtmosUSA.biz, E-Cig Mods
        "A great smoking alternative"

        Comment


        • #5
          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!

          Comment


          • #6
            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

            Comment


            • #7
              Do this!
              Attached Files
              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

              Comment


              • #8
                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"

                Comment


                • #9
                  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"

                  Comment


                  • #10
                    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!

                    Comment


                    • #11
                      Originally posted by muldrick
                      EDIT: Now how do I get rid of column D without screwing up column E?
                      you can just make it so narrow you can hardly see it, or you can highlight the entier column, cut and paste somewhere else, or you can right click on column label and "hide".
                      Old plans out the window because of an accident .
                      Have: M1-ATX, EPIA M10000, 256MB, 60GB 2.5", slim slot load DVD
                      Need: Time, HU integration, ideas for Lilli

                      Comment


                      • #12
                        That works. Thanks again.
                        AtmosUSA.biz, E-Cig Mods
                        "A great smoking alternative"

                        Comment


                        • #13
                          Freaks! All of you!
                          My boss is great - very cool guy, but as everyone else on this planet, he has a SEVERE nit-pick - TIME SHEETS. He must spend half of every day massaging the timesheets. And at least once a month preaches to us about the necessity of accurate time tracking...
                          I've had nightmares about it more than once.
                          Excel Dies!
                          http://www.jeepmp3.com/
                          CarPC Stolen. Starting over.
                          Ne1 recognize the avatar?

                          Comment


                          • #14
                            muldrick you can also paste values and remove the column if neccessary

                            highlight the column
                            ctrl+c
                            hold alt
                            E
                            S
                            V
                            release alt
                            RIP 1993 civic sedan
                            RIP 1993 civic Del Sol

                            Hello! VW Golf 1.8t

                            Comment

                            Working...
                            X