Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 02-11-2017, 09:20 AM
AndyK2 AndyK2 is offline Multiplying each number individually Windows 8 Multiplying each number individually Office 2016
Novice
Multiplying each number individually
 
Join Date: Feb 2017
Posts: 3
AndyK2 is on a distinguished road
Default Multiplying each number individually


How can I multiply numbers in the left row by 0.75 and make it show in the right row for all the numbers in the left column? For example, I made 2 numbers the way I want them to be:
Reply With Quote
  #2  
Old 02-11-2017, 09:30 AM
jeffreybrown jeffreybrown is offline Multiplying each number individually Windows Vista Multiplying each number individually Office 2007
Expert
 
Join Date: Apr 2016
Posts: 673
jeffreybrown has a spectacular aura aboutjeffreybrown has a spectacular aura about
Default

In B1 try...

=A1*0.75
Reply With Quote
  #3  
Old 02-11-2017, 09:47 AM
AndyK2 AndyK2 is offline Multiplying each number individually Windows 8 Multiplying each number individually Office 2016
Novice
Multiplying each number individually
 
Join Date: Feb 2017
Posts: 3
AndyK2 is on a distinguished road
Default

Yeah, I know that, but I need to do it for every number in column A... It's gonna take a while to do that with more than 150 numbers...
Reply With Quote
  #4  
Old 02-11-2017, 10:07 AM
jeffreybrown jeffreybrown is offline Multiplying each number individually Windows Vista Multiplying each number individually Office 2007
Expert
 
Join Date: Apr 2016
Posts: 673
jeffreybrown has a spectacular aura aboutjeffreybrown has a spectacular aura about
Default

Put the formula in B1 and copy down
Reply With Quote
  #5  
Old 02-11-2017, 10:13 AM
AndyK2 AndyK2 is offline Multiplying each number individually Windows 8 Multiplying each number individually Office 2016
Novice
Multiplying each number individually
 
Join Date: Feb 2017
Posts: 3
AndyK2 is on a distinguished road
Default

Quote:
Originally Posted by jeffreybrown View Post
Put the formula in B1 and copy down
If I will copy the formula it won't use the left number but the top left which is A1.. Don't you see the example?
Reply With Quote
  #6  
Old 02-11-2017, 10:53 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline Multiplying each number individually Windows 7 64bit Multiplying each number individually Office 2010 64bit
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,766
Pecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant future
Default

No it will adapt as A1 is a relative reference
Enter the formula as suggested in B1, put your cursor on the lower right angle selecting B1, it changes to a cross then double-click, it will extend automatically
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Multiplying each number individually How to change logo /dates in numerous word documents without changing each one individually? newi1 Word VBA 3 04-22-2016 07:02 PM
Multiplying an entire column by a single cell Jason167 Excel 2 11-04-2015 05:56 AM
How can I individually control page numbers in Word? OGWiseman Word 7 09-25-2015 03:02 PM
How to add data label individually in a stacked-bar chart? officeboy09 Excel 0 10-17-2013 01:26 AM
Word - Change Chart Colors Individually avalanche72 Word 0 09-18-2013 10:52 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 10:09 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft