We use cookies to provide you with a better experience. If you continue to use this site, we'll assume you're happy with this. Alternatively, click here to find out how to manage these cookies

hide cookie message
Contact Forum Editor

Send an email to our Forum Editor:


PLEASE NOTE: Your name is used only to let the Forum Editor know who sent the message. Both your name and email address will not be used for any other purpose.

Tech Helproom


It's free to register, to post a question or to start / join a discussion


 

double up in Excel


tonyq
Resolved

Likes # 0

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.

Like this post
compumac

Likes # 0

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

Like this post  
Woolwell

Likes # 0

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.

Like this post
tonyq

Likes # 0

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

Like this post

Reply to this topic

This thread has been locked.



IDG UK Sites

LG G Watch R video review: The most desirable Android Wear smartwatch

IDG UK Sites

Apple's 2014 highlights: the most significant Apple news of 2014

IDG UK Sites

2015 creative trends: leading designers & artists reveal the biggest influences & changes coming th)......

IDG UK Sites

Ultimate iOS 8 Tips: 35 awesome and advanced tips for using iOS 8 on iPhone and iPad