Replicate formula pattern

GRK5under

New Member
Joined
Apr 8, 2018
Messages
1
I have the following formulas in four different cells of Excel, as listed ...
Cell E2276: =IFERROR(E1138/E6,0)
Cell E2277: =IFERROR(E1421/E289,0)
Cell E2278: =IFERROR(E1704/E572,0)
Cell E2279: =IFERROR(E1987/E855,0)

...I would like to repeat these formulas in cells E2280, E2281, E2282, and E2283 with the exception that the formula incrementally changes as follows:
Cell E2280: =IFERROR(E1139/E7,0)
Cell E2281: =IFERROR(E1422/E290,0)
Cell E2282: =IFERROR(E1705/E573,0)
Cell E2283: =IFERROR(E1988/E856,0)

Unfortunately, when I drag or copy the formulas from cells E2276 through E2279 into E2280 through E2283, Excel increases the values in the formula by four and not one. In other words, Excel shows the formulas as:
Cell E2280: =IFERROR(E1142/E10,0)
Cell E2281: =IFERROR(E1425/E293,0)
Cell E2282: =IFERROR(E1708/E576,0)
Cell E2283: =IFERROR(E1991/E859,0)

Will someone please show me how to solve this problem? I have thousands of rows to complete this task with.

Thanks in advance.
 

Excel Facts

Wildcard in VLOOKUP
Use =VLOOKUP("Apple*" to find apple, Apple, or applesauce
one idea, create a helper column, 1 to 4, filter on 1, then fill with the formula, then filter on 2 and do the same etcetera until complete
 
Upvote 0

Forum statistics

Threads
1,225,477
Messages
6,185,210
Members
453,283
Latest member
Shortm88

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top