Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 02-27-2021, 09:40 AM
oscarlimerick oscarlimerick is offline How do I autofill my formula? Windows 8 How do I autofill my formula? Office 2013
Advanced Beginner
How do I autofill my formula?
 
Join Date: Jul 2020
Posts: 57
oscarlimerick is on a distinguished road
Default How do I autofill my formula?

Hi folks, in the attached spreadsheet example, what I aim to do is log the number of people canvassed daily in column D, and then have column E calculate the percentage of total people canvassed that day based on the total people number in cell G2. I have formatted all the cells in column E to percentage and one decimal place. The formula I entered in cell E4 was then "=D4/G2" and it correctly displays as 51.8% in cell E4. But how do I auto-fill this formula for the following days? (E5 to E12)? If I copy cell E4 and do a straight paste to cell E5 in attempts to enter the formula "=D5/G3", when it should be entering "=D5/G2". This results in a "#DIV/0!" error in cell E5 when the value I want displayed in here should be 56.5%.

Likewise dragging the right hand side of cell E4 down to Cell E5 produced the same error "=DIV/0!". Paste formula has the same result and paste link displays 51.8% when it should be 56.5%.

There must be an easier way to do this besides creating a new column beside each row and putting the number 2000 in all rows in that column. Thanks for your help.
Attached Files
File Type: xlsx PERCENTAGE EXAMPLE.xlsx (10.2 KB, 6 views)
Reply With Quote
  #2  
Old 02-27-2021, 11:24 AM
rollis13's Avatar
rollis13 rollis13 is offline How do I autofill my formula? Windows 10 How do I autofill my formula? Office 2016
Competent Performer
 
Join Date: Jan 2021
Location: Cordenons
Posts: 140
rollis13 will become famous soon enough
Default

You need to use absolute reference to cell G2, like this in E4 then pull down:
=D4/$G$2
Reply With Quote
  #3  
Old 02-27-2021, 11:31 AM
oscarlimerick oscarlimerick is offline How do I autofill my formula? Windows 8 How do I autofill my formula? Office 2013
Advanced Beginner
How do I autofill my formula?
 
Join Date: Jul 2020
Posts: 57
oscarlimerick is on a distinguished road
Default

Yes, that did the trick, many thanks
Reply With Quote
  #4  
Old 02-27-2021, 11:43 AM
rollis13's Avatar
rollis13 rollis13 is offline How do I autofill my formula? Windows 10 How do I autofill my formula? Office 2016
Competent Performer
 
Join Date: Jan 2021
Location: Cordenons
Posts: 140
rollis13 will become famous soon enough
Default

Glad I was able to help .
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I autofill my formula? Autofill data from web irisha Excel Programming 10 09-02-2016 05:30 PM
Creating AutoFill form - AutoFill information depending on a selection. RyanHarper Word 3 06-15-2015 01:01 PM
Autofill Stacybug1 Excel 2 01-28-2015 01:04 PM
How do I autofill my formula? Autofill Automation Parkiee1981 Excel 4 03-15-2013 01:24 PM
AutoCorrect Or AutoFill Johnny thunder Outlook 0 05-02-2011 03:37 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 04:18 PM.


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