+- MacResource (https://forums.macresource.com)
+-- Forum: My Category (https://forums.macresource.com/forumdisplay.php?fid=1)
+--- Forum: Tips and Deals (https://forums.macresource.com/forumdisplay.php?fid=3)
+--- Thread: Very Basic EXCEL question (/showthread.php?tid=13991)
Very Basic EXCEL question - Drew - 06-25-2006
I'm sure that everyone but me knows how to do this. I'd look in Excel help, but am not sure what to call it.
How do I change the divisor in a number of cells at the same time? I have a column of different totals that I want to divide by the same number, but want to experiment by changing that number to compare the results. Rather than changing the divisor in each cell one at a time, how can I change to divisor in all of them at the same time?
Thanks.
Re: Very Basic EXCEL question - C(-)ris - 06-25-2006
Make he divisor equal to a cell. Then change the number in that cell.
Re: Very Basic EXCEL question - WHiiP - 06-25-2006
what C(-)ris means is to use one cell as the divisor cell. Make it an absolute reference.
So, let's say that A1 represents the number that you want to divide. Making this a column the second number that you want to divide is A2 . . . then A3, etc.
Putting the answer in column B. In column B we will paste the formula that you create.
In cell C1 we will place the divisor. This number you may change and then get a different answer to each number in column A. That answer will appear in column B.
The formula that you paste in each cell in column B that you want answers to is:
A1/$C$1
This should be the formula you put in B1.
You can then copy it down the B column to as many rows as you need.
When you now change the number (divisor) in cell C1, all your rows will reflect the new answer.
HTH
Re: Very Basic EXCEL question - Drew - 06-25-2006
Thank you! I figured it out. I appreciate the help.