#1
|
|||
|
|||
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: |
#2
|
|||
|
|||
In B1 try...
=A1*0.75 |
#3
|
|||
|
|||
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...
|
#4
|
|||
|
|||
Put the formula in B1 and copy down
|
#5
|
|||
|
|||
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?
|
#6
|
||||
|
||||
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 |
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
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 |