Excel help required please - HotUKDeals
We use cookie files to improve site functionality and personalisation. By continuing to use HUKD, you accept our cookie and privacy policy.
Get the HUKD app free at Google Play

Search Error

An error occurred when searching, please try again!

Login / Sign UpSubmit

Excel help required please

33342 Avatar
banned6y, 4m agoPosted 6 years, 4 months ago
Not sure if this is possible but I need to add a set percentage onto a column of prices in excel, is there any easy way of doing it?

To explain slightly more the sheet is set out

PRODUCT COLOUR RRP TRADE PRICE

I need to add a set % to the whole trade price column, there's around 500 products so doing it individually takes hours!
33342 Avatar
banned6y, 4m agoPosted 6 years, 4 months ago
Options

All Comments

(17) Jump to unreadPost a comment
Comments/page:
1 Like #1
can you add the formula
[figure] divide by 100 multiply by [percentage amount]
1 Like #2
In a blank cell put the formula = (trade price cell) + whatever percentage you want
Then hover over the cell. In the bottom right hand corner, there is a black square. Put your mouse over this and your cursor turns into a black cross. Then click and drag and the formula will be repeated in all the other cells below. Hope this makes sense???
#3
Carley
can you add the formula[figure] divide by 100 multiply by [percentage amount]
marktuck
In a blank cell put the formula = (trade price cell) + whatever percentage you wantThen hover over the cell. In the bottom right hand corner, there is a black square. Put your mouse over this and your cursor turns into a black cross. Then click and drag and the formula will be repeated in all the other cells below. Hope this makes sense???

I don't feel very well................
banned#4
marktuck
In a blank cell put the formula = (trade price cell) + whatever percentage you want
Then hover over the cell. In the bottom right hand corner, there is a black square. Put your mouse over this and your cursor turns into a black cross. Then click and drag and the formula will be repeated in all the other cells below. Hope this makes sense???


that didn't work - although i probably did something wrong - ill point out here im useless with excel and need a step by step guide lol - thanks
1 Like #5
This screen shot may make it clearer?

http://www.btinternet.com/~marktuck/HUKD/Excel1.JPG

The highlighted part is the formula, the part circled is the box to drag
banned#6
nope lol
i did
=J2+40% then enter and it put 269.00% into the box lol

http://i141.photobucket.com/albums/r60/dvds2000/hukd/ex.jpg
banned#7
sorry pathetic forum software resizes everything so small you can#'t see it
1 Like #8
Right click the cell with 269% in and format cell to general.
banned#9
nope
what its doing is

I'm typing =J2+40% when I'm pressing enter its adding .4 onto the figure
1 Like #10
Why not just do =J2*1.4 then?

or long windidly

=J2+J2*40%
banned#11
because I've just worked that out - told you i knew nothing lol

still, I need to do it for the whole of the column, do i have to do each cell individually?
1 Like #12
No, as in the previous post you can grab the square in the right hand bottom corner and drag down the column or just double left click it and it will auto fill the column. Autofill will only continue as long as there is data in the corresponding cell in column J. If say J10 is empty then it will stop autofilling at J9.
1 Like #13
Or, once you have created the formula you need in one cell, highlight it with a left button click, then click the right mouse button and select 'copy' then highlight all the cells you want to add the formula to and then select 'paste'
#14
wots excel?

only kiddin
banned#15
ok getting there
if a do the forumla in a new colum and drag it down it does it right, but if I try to do it over the original values it goes mad lol.

I have found, if I do the new column then copy to notepad, undo changes, then paste from np back to the column that works, so that will do - certainly easier than doing 500+ products manually every week :)

Many thanks to everyone who helped
#16
You can't do it over the original values because they are part of the formula, you will then end up with circualar formula that never end. (if I am understanding you correctly)

If you are doing it every week you could write a simple macro (it is very easy) that will do it all at the press of a button.
#17
get the formula right in the first cell then select the following cells and use the autofill function.

Post a Comment

You don't need an account to leave a comment. Just enter your email address. We'll keep it private.

...OR log in with your social account

...OR comment using your social account

Thanks for your comment! Keep it up!
We just need to have a quick look and it will be live soon.
The community is happy to hear your opinion! Keep contributing!