Millicent Bystander
Clan admin
Karma: 740
 Offline
Gender: 
Posts: 2523
WDG Conception Expert
|
 |
« on: November 13, 2008, 12:10:14 PM » |
|
I have to increase several hundred prices in a word document by 7%. This could take some time but I'm sure there must be a way of doing it in Excel and then putting it back in the brochure in Word.
In the past I have managed to avoid spreadsheets and have absolutey no idea of how to go about changing percentages.
|
|
|
|
|
Logged
|
I find myself stark naked except for a pair of latex gloves attempting to pull on a pair of red tights on in my parent's spare bedroom.
|
|
|
|
Junta
Guest
|
|
« Reply #1 on: November 13, 2008, 12:23:41 PM » |
|
People normally embed Excel tables or just edit cells in Excel and copy / paste into a word table. But either suggestion relies on Excel knowledge.
If a cell were to show 85%, the underlying value in Excel is 0.85 - just edit the cell value?
|
|
|
|
|
Logged
|
|
|
|
|
mark
Guest
|
|
« Reply #2 on: November 13, 2008, 12:28:14 PM » |
|
Um you can copy past all the values into excel then put *1.07 into all of them and then you can as Junta said embed them in word.
I think that would work...
|
|
|
|
|
Logged
|
|
|
|
|
Junta
Guest
|
|
« Reply #3 on: November 13, 2008, 12:31:19 PM » |
|
Um you can copy past all the values into excel then put *1.07 into all of them and then you can as Junta said embed them in word.
I think that would work...
Good idea - but I was deliberately trying to avoid formulae in case Milli wasn't happy about that  |
|
|
|
|
Logged
|
|
|
|
|
mark
Guest
|
|
« Reply #4 on: November 13, 2008, 12:35:01 PM » |
|
Um you can copy past all the values into excel then put *1.07 into all of them and then you can as Junta said embed them in word.
I think that would work...
Good idea - but I was deliberately trying to avoid formulae in case Milli wasn't happy about that one would expect him to know at least the basics of excel when asking this kind of question but of course he might not know a thing about it but still my suggestion was rather simple. You just put 1.07 in one cell, an empty cell and write ='name of cell you want to have 7% increase on'*'name of the 1.07 cell' then put $-signs around the letter of the letter of the 1.07 cells name in the formula, now it should be possible to just drag it down and get the values required. |
|
|
|
« Last Edit: November 13, 2008, 12:38:04 PM by mark »
|
Logged
|
|
|
|
Millicent Bystander
Clan admin
Karma: 740
Offline
Gender:
Posts: 2523
WDG Conception Expert
|
|
« Reply #5 on: November 13, 2008, 12:39:49 PM » |
|
Thank you Mark, idiots guide very helpful, saved me hours of pointless work which I can now spend trolling the forum.
+1 karma
|
|
|
|
|
Logged
|
I find myself stark naked except for a pair of latex gloves attempting to pull on a pair of red tights on in my parent's spare bedroom.
|
|
|
|
mark
Guest
|
|
« Reply #6 on: November 13, 2008, 12:49:11 PM » |
|
So it worked? FUCK YEAH!
|
|
|
|
|
Logged
|
|
|
|
|
mark
Guest
|
|
« Reply #7 on: November 13, 2008, 01:01:05 PM » |
|
So it worked? FUCK YEAH!
You're awesome! |
|
|
|
|
Logged
|
|
|
|
mode_seven
does not like the cone of shame
Clan leader
Karma: 939
Offline
Gender:
Posts: 3226
\o/ ^o^ o< /o\
|
|
« Reply #8 on: November 13, 2008, 01:31:19 PM » |
|
So it worked? FUCK YEAH!
You're awesome! Y'see, I was going to applaud you because I felt sorry for everyone smiting you, but now see what you've made me gone and do.  |
|
|
|
|
Logged
|
Power: Why am I kritzed? OH GOD I killed my wife. Burnalot: I AM VERY DRINK Burnalot: I love little girls in games LoL Referral Link Thingy |
|
|
|
Hzza
Guest
|
|
« Reply #9 on: November 13, 2008, 01:32:34 PM » |
|
So it worked? FUCK YEAH!
You're awesome! Y'see, I was going to applaud you because I felt sorry for everyone smiting you, but now see what you've made me gone and do. +1 karma for bandwagon jumping! |
|
|
|
|
Logged
|
|
|
|
Millicent Bystander
Clan admin
Karma: 740
Offline
Gender:
Posts: 2523
WDG Conception Expert
|
|
« Reply #10 on: November 13, 2008, 01:45:13 PM » |
|
Just realised the last time I used a spreadsheet this much was 1991 when I was 18 and working for a property management company.
I feel old
|
|
|
|
|
Logged
|
I find myself stark naked except for a pair of latex gloves attempting to pull on a pair of red tights on in my parent's spare bedroom.
|
|
|
Gonk
Clan member
Karma: 52
Offline
Posts: 320
|
|
« Reply #11 on: November 13, 2008, 03:37:04 PM » |
|
lol :0 unfortunately I use a massive one every day to help plan labour  When the system went down it was funny to watch people who didnt know what papaer and pen were for!  |
|
|
|
|
Logged
|
|
|
|
|
Gasman
Guest
|
|
« Reply #12 on: November 13, 2008, 08:07:29 PM » |
|
7%!!! Guess you sell mortgages! LOL
|
|
|
|
|
Logged
|
|
|
|
|
Junta
Guest
|
|
« Reply #13 on: November 13, 2008, 10:27:27 PM » |
|
7%!!! Guess you sell mortgages! LOL
Applaud  |
|
|
|
|
Logged
|
|
|
|
Gonk
Clan member
Karma: 52
Offline
Posts: 320
|
|
« Reply #14 on: November 14, 2008, 02:36:57 AM » |
|
lol n1
|
|
|
|
|
Logged
|
|
|
|
|
Total Members: 311
