topic Re: excel problem in Selling

excel problem

t0psales — Wed, 16 Apr 2014 01:59:22 GMT

I have a collum that is my buy price, I want to ad say 10% to that, I have over 1200 items I need to do it to, I understand that I can "paste special" but what is the formula.

I were thinking but the dont seem to work

=a1+10%

and somehow get the same formula for all of the rows

or =a1*110%

Any ideas?

Re: excel problem

xmystical_memoriesx — Wed, 16 Apr 2014 02:14:26 GMT

+a1*110%

$10 x 110% = $11.00

Re: excel problem

t0psales — Wed, 16 Apr 2014 02:19:57 GMT

not working, but basic idea of what I want to do

Re: excel problem

marshbunyip — Wed, 16 Apr 2014 02:57:06 GMT

+a1 * 1.1

Re: excel problem

clarry100 — Wed, 16 Apr 2014 05:37:48 GMT

If your starting value (say 10) is in cell A1

And the result you want is to be in B1 then just copy this text including the "=" sign into B1

=A1*110%

The value you the see in B1 will be 11, but the formula in there will be the text above.

Then when you just copy this formula down it will automatically self-adjust to become

=A1*110%

=A2*110%

=A3*110%

etc

Re: excel problem

my_wishes_and_dreams — Thu, 17 Apr 2014 04:17:33 GMT

Click on B1

Then =A1*1.1

If A1 is 10 then B1 will be 11

Then just drag the B1 formula down to the end of your listings

Re: excel problem

my_wishes_and_dreams — Thu, 17 Apr 2014 04:24:53 GMT

ooops mouse over B! until you get the +, should be in the bottom right hand corner .Right click and then drag the formula down over the required number of cells. Excell will automatically put the formule in the "B" column cells