Solved Copy Excel Formulas down a column

October 20, 2016 at 11:52:47
Specs: Windows 7
 I don't have Skype and I can't copy Excel formulas in any direction...comes up with a div/0 error everytime. tried the double-click the plus sign trick but nothing I tried worked.

See More: Copy Excel Formulas down a column

✔ Best Answer
October 21, 2016 at 07:28:53
 Just to add to what Derby has said, if your formula is always going to divide by the number 50 cells below then you will have something likeA1/A50A2/A51A3/A53But if everything is meant to be divided by A50 then you will have to absolute that cell in your formula like this A1/\$A\$50This will mean that when you drag it down your formulas will look likeA1/\$A\$50A2/\$A\$50A3/\$A\$50etc

#1
October 20, 2016 at 12:11:38
 I'm not sure Skype has anything to do with it. :)This is a Dividing by zero error.What formula are you trying to copy?

Report •

#2
October 20, 2016 at 12:20:45
 I have a formula that divides the cell immediately to the left by another about 50 rows below the left cell. B2 would have a formula =sum(A1/A50). In the old days, I could grab the little plus sign and pull it all the down. Now, the B cells would have the results...

Report •

#3
October 21, 2016 at 04:03:37
 Is there data in A50 and below? If those cells are empty, you'll get a #DIV/0! error.

Report •

Related Solutions

#4
October 21, 2016 at 07:28:53
✔ Best Answer
 Just to add to what Derby has said, if your formula is always going to divide by the number 50 cells below then you will have something likeA1/A50A2/A51A3/A53But if everything is meant to be divided by A50 then you will have to absolute that cell in your formula like this A1/\$A\$50This will mean that when you drag it down your formulas will look likeA1/\$A\$50A2/\$A\$50A3/\$A\$50etc

Report •

#5
October 21, 2016 at 11:50:53
 thanks! that absolutely, notice the pun, did the trick...

Report •