excel formula

  24army 10:46 20 May 03
Locked

I have a column of figures that require uppping by 10%. I have done the first number (A1) which is 17.77 by =17.77+10%. Now I can't get the balance of the column to increase by 10% by pasting. How do I do this without the bother of opening another column? Can anyone tell me what I am doing wrong or is there no other way than to open a second column and paste an = formula.

  VoG™ 10:59 20 May 03

Put the number 1.1 in a cell. Then copy that cell.

Now select your column of numbers, Edit, Paste Special and tick the Multiply operation.

  harristweed 11:00 20 May 03

easiest way.

insert a column next to column A.

Enter in cell adjacent to A1 (possibly B1)

= a1*1.1

Put the cursor on the bottom right hand corner of this cell, the cursor will change to a '+'

Drag this down all the cells in the column and this will insert the correct formula into all the cell.

done!

  harristweed 11:01 20 May 03

beat mr to it with a better way - i'm going back to bed

  24army 13:31 20 May 03

vog. Many thanks for the prompt response. Solution worked supebly

This thread is now locked and can not be replied to.

Best phone camera 2016/2017: Galaxy S7 vs iPhone 7 vs Google Pixel vs HTC 10 Evo vs OnePlus 3T vs…

1995-2015: How technology has changed the world in 20 years

These are the Best Christmas Ads and Studio Projects of 2016

Super Mario Run preview | Hands-on first impressions of Super Mario Run: Mario's iPhone & iPad…