MegaSack DRAW - This year's winner is user - rgwb
We will be in touch
I have some price lists i wish to increase by 4.1%. They all reside in column D.....so column D4 -> D294.
Does any kind soul out there know how to add the formula to get a blanket increase over the above cells??
Thanks!!!!
Multiply each cell by 1.041, for example add into cell E4 for formula =D4*1.041 then copy/paste that down to E294
(EdIT: this may well win the prize as the most basic Excel question ever asked)
Well there are many ways to do this but what I'd do is enter the percentage increase you want to employ into a cell, say E1, change the number type to a percentage then use the formula =D1*$E$1 in whatever cells you want the output. You can then copy this formula down the new colum to apply it to everything in the original column.
Edit. This has the advantage that if you want to change the percentage to be applied you'll only have to change the value in one cell.
Hey, EVERYTHING is easy when you know how!! 🙂
I shall give that a try and see how it goes. Thanks.
I'm guessing that you have fixed numbers in columns D4-D294 and you want to increase those numbers rather than increase the numbers in another column. What I would do is:
1. Make a copy of the spreadsheet in case you screw up
2. Find a blank column near column D = say column E
3. Enter the formula in E4 = 1.041 * D4
4. Copy that formula into E5 to E294
5. Then copy all of the formulae in E4 to E294
6. Now, select D4 to D294
7. Right click on that select and 'paste special'
8. Select paste values
9. Delete what you had in E4 to E294
edit: I type WAY too slow clearly
Leffeboy, good lad - thats exactly what i was after!
@FB, I was just teasing you ! Note @leffeboy's steps 5-9 will delete the original price list and replace it with the new one which is perhaps what you want to end up with
Of course after you are done you should have a day off (couldn't help myself!)