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
CriticalError

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
HammerHead

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
strollin

W7 Ult desktop, W8.1 laptop, W8.1 tablet, Win 10 TP VM
 
 

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





Similar help and support threads
Thread Forum
Can I compare 2 Excel spreadsheets cell by cell?
I have an Excel 2010 workbook comprising a simple organization membership list, consisting of names, addresses, etc., for nearly 2,000 members, grouped into 5 chapters' sheets, in a single Excel 2010 file. Every time I sit down to enter updates for any member, or add new members, etc., I always ...
Microsoft Office
How to go back from Excel 2010 64 bit to Excel 2010 32 bit
I have an important program that uses a DLL that only works with Excel 2010 32 bit. I'm running Excel 2010 64 bit now -- how do I install the 32 bit version? I have the CD which has both versions on it. But when I run Setup, it gives me options that I don't understand for this limited purpose. In...
Microsoft Office
Excel cell
Office 2010/Excel I accidentally entered an email address into a cell and now I can't get rid of that format in that cell. No matter what I do, whenever I try to enter text into that cell it is always illuminated in blue and is underlined, just like email addresses are. How can I make this cell...
Microsoft Office
Excel: How can I insert the value of cell into ActiveX button caption?
Hi, I'm using Office 2007 and I have an Excel file that I have to update often. Therefore I will automate certain tasks using macros accessible by ActiveX Control command buttons. However, I would like for the captions to be relative to information found in certain cells; examples of a caption I...
Microsoft Office
Excel 2007 Home and Studentl: calculation results in blank cell
A strange thing is happening on one of my Excel spreadsheets. If I put a value in cell A and another in B and use cell C for the result of my calculation, cell C produces a blank. Cell C, however, does show what is input directly to it. Please! Why is that happening and what is the cure?
Microsoft Office
Formatting Excel 2010, Excel 2003
Hello, I want to create a table as in the drawing below, where the first cell is table-wide (as it contains the heading common (pertaining?) to all columns and rows under it) but, and this is where I cannot get it together, where those cells are divided into several columns. It's a cinch when...
Microsoft Office

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 13:27.

Twitter Facebook Google+



Windows 7 Forums

Seven Forums Android App Seven Forums IOS App