# Thread: Excel Formula?

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

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?

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 ?

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

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.

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

7. Do this!

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.

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?

10. hide it

Page 1 of 2 12 Last

#### Posting Permissions

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