Hello, I am having troubles with autofilling. For example, I want to autofill the IF Function "=IF(ISBLANK($A1), 0,1)" to "=IF(ISBLANK($A10), 0,1" from cells B1 to B10. However, if I start off "=IF(ISBLANK($A1), 0,1" to "=IF(ISBLANK($A3), 0,1", it repeats over and over again. I tried changing the formula to "=IF(ISBLANK(A1), 0,1" but the cells would read "=IF(ISBLANK(B1), 0,1", =IF(ISBLANK(C1), 0,1" and so on. May i know how to solve this?
