Windows 7 Forums
Welcome to Windows 7 Forums. Our forum is dedicated to helping you find support and solutions for any problems regarding your Windows 7 PC be it Dell, HP, Acer, Asus or a custom build. We also provide an extensive Windows 7 tutorial section that covers a wide range of tips and tricks.


Windows 7: Excel 2010 Multiply cell


17 Sep 2012   #1

Windows 7 Ultimate 32
 
 
Excel 2010 Multiply cell

I am kinda stuck with this issue, basically what I want to do is multiply any number which is put in row H by 10 and put the value in the next cell in row I, how can I do this?

Thanks

My System SpecsSystem Spec
.

17 Sep 2012   #2

win 7 X64 Ultimate SP1
 
 
May Not Understand

I may not understand what you are asking. But if you enter this into the cell in which you want the result as a formula. "=H1 * 10" (no qutoes). This will multiply H1 by ten.
My System SpecsSystem Spec
17 Sep 2012   #3

Win 7 Ultimate (64-bit), Win 8.1.1 (64-bit)
 
 

You will need to put the formula that HammerHead posted "=H1*10" into the the cell I1 then copy that formula into every row in column I that you want the formula to work with. Excel will update the formula each time you copy it so that it will change to "=H2*10" then "=H3*10", etc...
My System SpecsSystem Spec
.


Reply

 Excel 2010 Multiply cell




Thread Tools




Our Sites

Site Links

About Us

Find Us

Windows 7 Forums is an independent web site and has not been authorized, sponsored, or otherwise approved by Microsoft Corporation. "Windows 7" and related materials are trademarks of Microsoft Corp.

Designer Media Ltd

All times are GMT -5. The time now is 12:28 AM.
Twitter Facebook Google+



Windows 7 Forums

Seven Forums Android App Seven Forums IOS App
  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33