Forum Discussion
IF Function
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(I...
Use relative references, except when you need to copy your formulas across columns, wherein you must use absolute reference for the column.