Excel Formula?

**muldrick** · 07-19-2005, 09:18 PM

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

**migel628** · 07-19-2005, 09:23 PM

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?

**frodobaggins** · 07-19-2005, 09:23 PM

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 ?

**muldrick** · 07-19-2005, 09:28 PM

Yes, correct. But do I have to create a formula for each cell?

**frodobaggins** · 07-19-2005, 09:33 PM

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.

**migel628** · 07-19-2005, 09:34 PM

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

**ENerd** · 07-19-2005, 09:37 PM

Do this!

**muldrick** · 07-19-2005, 09:40 PM

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.

**muldrick** · 07-19-2005, 09:46 PM

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?