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.
In A2 put A1*2
In A3 put A2*2
In A4 put A3*2
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.
thank you to both of you for your reply's,worked a treat.
This thread is now locked and can not be replied to.
iMac Pro review
3D illustrator Billelis on how to promote yourself on social media
Apple Music : comment obtenir 3 mois gratuits ?
© Copyright 2018 IDG UK. All Rights Reserved.