Go Back   Computer Forums > General Computing > Hardware
Click Here to Login
Join Computer forums Today


Reply
 
Thread Tools Search this Thread Display Modes
 
Old 01-09-2007, 12:54 PM   #1
Baseband Member
 
Join Date: Jan 2007
Posts: 66
Default Anyone with knowledge of MS Excel...

I would like to change a whole bunch of cells, in a 64 x 11 rectangle. The values in each cell are dollar amounts, and I would like to increase each of these values by 5%. That is, if a dollar amount is $1325.00, and increase in 5% would have it equal $1391.25. Is there a very fast way to do this?
__________________

wally222 is offline   Reply With Quote
Old 01-09-2007, 01:05 PM   #2
Daemon Poster
 
kjman87's Avatar
 
Join Date: Oct 2006
Posts: 806
Send a message via AIM to kjman87
Default Re: Anyone with knowledge of MS Excel...

Quote:
Originally Posted by wally222
I would like to change a whole bunch of cells, in a 64 x 11 rectangle. The values in each cell are dollar amounts, and I would like to increase each of these values by 5%. That is, if a dollar amount is $1325.00, and increase in 5% would have it equal $1391.25. Is there a very fast way to do this?
you could write a macro to do it...ill make a quick one and post it just tell me the range of cells like A1 to like J11 or something


ill write a macro or something that does that......or you could make a new box at the bottem

and write something like this: =A1 * 1.05
then drag that equation system over and down then cut that and paste special
the values in the top boxes to replace them...either way let me know
__________________

__________________
New Desktop: Core i7 860, EVGA P55 SLI, 2x PNY GTX260s in SLI, Antec Quattro 1kW PSU,4GB XMS3 DDR3-1600, Antec 300 Case, 2xSeagate 500GB, 1TB Samsung
Old Desktop: Intel E8400, Seagate 7200.11 500GB HDD, 320GB WD, 250GB Seagate, Asus 9800GTX+,4GB Corsair Ballistix, Asus P5Q Pro, Antec 500W PSU, 2 19" WS
Laptop: HP dv4-1155se
Car~07 Mazda 3s 5spd 2.3L: Simota CAI, Borla Cat-Back, Cat Delete, Lower Engine Mount, 1.5" Drop...and more...haha
kjman87 is offline   Reply With Quote
Old 01-09-2007, 01:08 PM   #3
Baseband Member
 
Join Date: Jan 2007
Posts: 66
Default Re: Anyone with knowledge of MS Excel...

It is a rectangle with cell dimensions of M8 x W69
wally222 is offline   Reply With Quote
Old 01-09-2007, 01:09 PM   #4
Daemon Poster
 
kjman87's Avatar
 
Join Date: Oct 2006
Posts: 806
Send a message via AIM to kjman87
Default Re: Anyone with knowledge of MS Excel...

Quote:
Originally Posted by wally222
It is a rectangle with cell dimensions of M8 x W69
try that second method I said
__________________
New Desktop: Core i7 860, EVGA P55 SLI, 2x PNY GTX260s in SLI, Antec Quattro 1kW PSU,4GB XMS3 DDR3-1600, Antec 300 Case, 2xSeagate 500GB, 1TB Samsung
Old Desktop: Intel E8400, Seagate 7200.11 500GB HDD, 320GB WD, 250GB Seagate, Asus 9800GTX+,4GB Corsair Ballistix, Asus P5Q Pro, Antec 500W PSU, 2 19" WS
Laptop: HP dv4-1155se
Car~07 Mazda 3s 5spd 2.3L: Simota CAI, Borla Cat-Back, Cat Delete, Lower Engine Mount, 1.5" Drop...and more...haha
kjman87 is offline   Reply With Quote
Old 01-09-2007, 01:11 PM   #5
Baseband Member
 
Join Date: Jan 2007
Posts: 66
Default Re: Anyone with knowledge of MS Excel...

I tried that earlier on, however when I cut and paste them where the original boxes were, I get an error because it is those original boxes that I'm referencing in the equation. Hence my problem...
wally222 is offline   Reply With Quote
Old 01-09-2007, 01:30 PM   #6
Daemon Poster
 
kjman87's Avatar
 
Join Date: Oct 2006
Posts: 806
Send a message via AIM to kjman87
Default Re: Anyone with knowledge of MS Excel...

Quote:
Originally Posted by wally222
I tried that earlier on, however when I cut and paste them where the original boxes were, I get an error because it is those original boxes that I'm referencing in the equation. Hence my problem...
use the paste special command...it should be right under past when you right click
__________________
New Desktop: Core i7 860, EVGA P55 SLI, 2x PNY GTX260s in SLI, Antec Quattro 1kW PSU,4GB XMS3 DDR3-1600, Antec 300 Case, 2xSeagate 500GB, 1TB Samsung
Old Desktop: Intel E8400, Seagate 7200.11 500GB HDD, 320GB WD, 250GB Seagate, Asus 9800GTX+,4GB Corsair Ballistix, Asus P5Q Pro, Antec 500W PSU, 2 19" WS
Laptop: HP dv4-1155se
Car~07 Mazda 3s 5spd 2.3L: Simota CAI, Borla Cat-Back, Cat Delete, Lower Engine Mount, 1.5" Drop...and more...haha
kjman87 is offline   Reply With Quote
Old 01-09-2007, 01:39 PM   #7
Baseband Member
 
Join Date: Jan 2007
Posts: 66
Default Re: Anyone with knowledge of MS Excel...

Thank you very much
wally222 is offline   Reply With Quote
Old 01-09-2007, 01:51 PM   #8
Daemon Poster
 
kjman87's Avatar
 
Join Date: Oct 2006
Posts: 806
Send a message via AIM to kjman87
Default Re: Anyone with knowledge of MS Excel...

np
__________________

__________________
New Desktop: Core i7 860, EVGA P55 SLI, 2x PNY GTX260s in SLI, Antec Quattro 1kW PSU,4GB XMS3 DDR3-1600, Antec 300 Case, 2xSeagate 500GB, 1TB Samsung
Old Desktop: Intel E8400, Seagate 7200.11 500GB HDD, 320GB WD, 250GB Seagate, Asus 9800GTX+,4GB Corsair Ballistix, Asus P5Q Pro, Antec 500W PSU, 2 19" WS
Laptop: HP dv4-1155se
Car~07 Mazda 3s 5spd 2.3L: Simota CAI, Borla Cat-Back, Cat Delete, Lower Engine Mount, 1.5" Drop...and more...haha
kjman87 is offline   Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off



All times are GMT -5. The time now is 06:05 AM.


Powered by vBulletin® Version 3.8.8 Beta 4
Copyright ©2000 - 2017, vBulletin Solutions, Inc.
Search Engine Friendly URLs by vBSEO 3.6.0