Home

IF Function

%3CLINGO-SUB%20id%3D%22lingo-sub-498376%22%20slang%3D%22en-US%22%3EIF%20Function%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-498376%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%20I%20am%20having%20troubles%20with%20autofilling.%20For%20example%2C%20I%20want%20to%20autofill%20the%20IF%20Function%20%22%3DIF(ISBLANK(%24A1)%2C%200%2C1)%22%20to%20%22%3DIF(ISBLANK(%24A10)%2C%200%2C1%22%20from%20cells%20B1%20to%20B10.%20However%2C%20if%20I%20start%20off%20%22%3DIF(ISBLANK(%24A1)%2C%200%2C1%22%20to%20%22%3DIF(ISBLANK(%24A3)%2C%200%2C1%22%2C%20it%20repeats%20over%20and%20over%20again.%20I%20tried%20changing%20the%20formula%20to%20%22%3DIF(ISBLANK(A1)%2C%200%2C1%22%20but%20the%20cells%20would%20read%20%22%3DIF(ISBLANK(B1)%2C%200%2C1%22%2C%26nbsp%3B%3DIF(ISBLANK(C1)%2C%200%2C1%22%20and%20so%20on.%20May%20i%20know%20how%20to%20solve%20this%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-498376%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-498492%22%20slang%3D%22en-US%22%3ERe%3A%20IF%20Function%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-498492%22%20slang%3D%22en-US%22%3EUse%20relative%20references%2C%20except%20when%20you%20need%20to%20copy%20your%20formulas%20across%20columns%2C%20wherein%20you%20must%20use%20absolute%20reference%20for%20the%20column.%3C%2FLINGO-BODY%3E
Highlighted
JunSheng
Occasional Contributor

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?

1 Reply
Highlighted
Use relative references, except when you need to copy your formulas across columns, wherein you must use absolute reference for the column.
Related Conversations
Make Share function in Edge more useful
HotCakeX in Discussions on
2 Replies
function talking to table storage
donquijote in Compute on
0 Replies
Calculated column help
gopalaraoa in SharePoint on
1 Replies
Excel If Functions
Mfouad2255 in Excel on
10 Replies
Combining IF and INDEX functions
Hans van Deursen in Windows PowerShell on
2 Replies