Thread: How do I autofill my formula?
View Single Post
 
Old 02-27-2021, 11:24 AM
rollis13's Avatar
rollis13 rollis13 is offline Windows 10 Office 2016
Competent Performer
  
Join Date: Jan 2021
Location: Cordenons
Posts: 143
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