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.
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.