Excel 2010 Multiply cell

C

CriticalError

New member
Member
VIP
Local time
4:00 PM
Messages
118
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 Computer

OS
Windows 7 Ultimate 32
CPU
AMD Athlon 64 X2 4400+ Brisbane 65nm Technology
Motherboard
ASUSTek Computer INC. NARRA3 (Socket AM2 )
Memory
Size 3072 MBytes
Graphics Card(s)
ATI Radeon HD 3450
Sound Card
Realtek High Definition Audio
Monitor(s) Displays
Name Generic PnP Monitor on ATI Radeon HD 3450 Current Resol
Screen Resolution
1440x900
Hard Drives
Manufacturer Seagate
Form Factor 3.5"
Interface ATA
Capacity 352GB
Real size 360,080,695,296 bytes
RAID Type None
S.M.A.R.T
S.M.A.R.T not supported
Partition 0
Partition ID Disk #0, Partition #0
Disk Letter C:
File System NTFS
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 Computer

Computer Manufacturer/Model Number
BGC (Bob's Garage Crew)
OS
win 7 X64 Ultimate SP1
CPU
I3770K
Motherboard
Asus P8Z77-V Deluxe
Memory
G Skill F3-14900CL9-4GBXL x 4
Graphics Card(s)
NVIDIA GeForce GTX670 + Intel 4000
Sound Card
Realtek HD 5.1 (MOB)
Monitor(s) Displays
Asus VW224T (1)
Screen Resolution
1920 x 1080
Hard Drives
SATA Corsair Force GT 2.5" 180GB (System) Sata 3
OCZ Vertex3 120GB
OCZ Vertex 2 120GB 2.5" SATA II
ST31000524AS 1000.2GB
WD15EARS (External)
PSU
CoolerMaster 1000 Watt
Case
CoolerMaster HAF X
Cooling
CPU -- CoolerMaster 520N
Keyboard
MS Wireless 3000 V2
Mouse
MS Wireless 3000 V2
Internet Speed
Cable
Antivirus
Norton Internet Security
Browser
IE9
Other Info
AMI Bios 1805
OC'd 3%
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 Computer

Computer type
PC/Desktop
Computer Manufacturer/Model Number
Home Built desktop, Dell G15 5511 Gaming laptop,MS Surface Pro 7 tablet
OS
W10 Pro desktop, W11 laptop, W11 Pro tablet (all 64-bit)
CPU
3.7Ghz 8700K i7, i7-11800H, i7-1065G7
Motherboard
ASUS TUF Z370-Pro Gaming in desktop
Memory
16G desktop, 16G laptop, 4G tablet
Graphics Card(s)
AMD Radeon RX580, RTX 3060, Intel Iris Plus
Sound Card
High Definition Audio (Built-in to mobo)
Monitor(s) Displays
Samsung U32J59 32" (2x), 15.6", 12"
Screen Resolution
3840x2160, 3840x2160, 1920x1080, 2160x1440
Hard Drives
500G SSD for OS; 2T, 10T & 15T HDDs for Data on Desktop, 1TB SSD laptop, 128G SSD tablet.
PSU
Corsair CX 750M
Case
Antec 100
Cooling
CM 212+
Keyboard
IBM Model M - used continuously since 1986
Mouse
Microsoft Pro IntelliMouse
Internet Speed
400M down 8M up
Antivirus
Windows Defender
Browser
FireFox
Other Info
Built my first computer (8Mhz 8088cpu, 640K RAM, 20MB HDD, 2 360K floppy drives) in 1985 and have been building them for myself, relatives and friends ever since.
You must log in or register to reply here.
Back
Top