double up in Excel

  tonyq 17:40 PM 23 Mar 12

Can anyone tell me what formula I need in Excel 2007 which double in the next cell,eg 1p in cell A1 2p in A2 4p in cell A3 ect.

  compumac 18:07 PM 23 Mar 12

In A2 put A1*2 In A3 put A2*2 In A4 put A3*2

  Woolwell 18:13 PM 23 Mar 12

If you put in A1 .01 and use currency to 1p then A2 put =A1*2 then highlight that cell move your mouse to the bottom right corner and drag down Excel will automatically fill in the formula and work out the answer for as far as down as you wish.

  tonyq 18:18 PM 23 Mar 12

compumac/Woolwell thank you to both of you for your reply's,worked a treat.


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

How to watch Rugby World Cup 2015 online: Watch live, catch up on-demand & stream the 2015 Rugby…

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

How to watch Adobe Max 2015: See Adobe unveil new Creative Cloud features for Photoshop,…

Live Photo tips: How to take Live Photos on the iPhone 6s, how to view, share, edit and find Live…