|
 |
07-19-2005, 09:18 PM
|
#1
|
|
FLAC
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
|
|
|
|
|
|
Advertisement
|
Sponsored links
|
|
07-19-2005, 09:23 PM
|
#2
|
|
FLAC
Join Date: Mar 2004
Location: New Windsor, NY
Posts: 1,113
|
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
|
|
|
|
|
07-19-2005, 09:23 PM
|
#3
|
|
I'm sorry, and you are....?
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 ?
__________________
[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!
|
|
|
|
|
07-19-2005, 09:28 PM
|
#4
|
|
FLAC
Join Date: Jun 2004
Location: South-Central PA
Posts: 1,241
|
Yes, correct. But do I have to create a formula for each cell?
|
|
|
|
|
07-19-2005, 09:33 PM
|
#5
|
|
I'm sorry, and you are....?
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!
|
|
|
|
|
07-19-2005, 09:34 PM
|
#6
|
|
FLAC
Join Date: Mar 2004
Location: New Windsor, NY
Posts: 1,113
|
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
|
|
|
|
|
07-19-2005, 09:37 PM
|
#7
|
|
Variable Bitrate
Join Date: Feb 2005
Location: Wichita, KS
Posts: 230
|
Do this!
__________________
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
|
|
|
|
|
07-19-2005, 09:40 PM
|
#8
|
|
FLAC
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.
|
|
|
|
|
Sponsored links
|
|
Advertisement
|
|
|
07-19-2005, 09:46 PM
|
#9
|
|
FLAC
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?
Last edited by muldrick; 07-19-2005 at 09:53 PM.
|
|
|
|
|
07-19-2005, 09:59 PM
|
#10
|
|
I'm sorry, and you are....?
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!
|
|
|
|
|
07-19-2005, 10:00 PM
|
#11
|
|
Constant Bitrate
Join Date: Oct 2004
Location: Schenectady, NY
Posts: 175
|
Quote: 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
Last edited by RPI Geek; 07-20-2005 at 03:18 AM.
|
|
|
|
|
07-19-2005, 10:01 PM
|
#12
|
|
FLAC
Join Date: Jun 2004
Location: South-Central PA
Posts: 1,241
|
That works. Thanks again. 
|
|
|
|
|
07-19-2005, 10:16 PM
|
#13
|
|
FLAC
Join Date: Dec 2000
Location: Afton MN
Posts: 1,120
|
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!
|
|
|
|
|
07-21-2005, 01:50 AM
|
#14
|
|
Variable Bitrate
Join Date: Apr 2005
Location: NJ
Posts: 388
|
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
|
|
|
|
|
Sponsored links
|
|
Advertisement
|
|
| Thread Tools |
|
|
| Display Modes |
 Linear Mode
|
Posting Rules
|
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
HTML code is Off
|
|
|
All times are GMT -5. The time now is 06:52 AM.
| |
