Formula Question

%3CLINGO-SUB%20id%3D%22lingo-sub-2749897%22%20slang%3D%22en-US%22%3EFormula%20Question%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2749897%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20trying%20to%20drag%20down%20a%20formula%20but%20want%20to%20keep%20the%20false%20value%20the%20same%20for%20each%20cell.%26nbsp%3B%20How%20can%20I%20accomplish%20this%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CFONT%20color%3D%22%23000000%22%3E%3DIF(Dependencies!O17%3D%22%22%2C%22%22%2C%3CFONT%20color%3D%22%23FF0000%22%3EDependencies!O9%3C%2FFONT%3E%26amp%3BCHAR(10)%26amp%3BIF(Dependencies!P17%3D%22%22%2C%22%22%2C%3CFONT%20color%3D%22%23FF0000%22%3EDependencies!P9%3C%2FFONT%3E%26amp%3BCHAR(10)%26amp%3BIF(Dependencies!Q17%3D%22%22%2C%22%22%2C%3CFONT%20color%3D%22%23FF0000%22%3EDependencies!Q9%3C%2FFONT%3E%26amp%3BCHAR(10)%26amp%3BIF(Dependencies!R17%3D%22%22%2C%22%22%2C%3CFONT%20color%3D%22%23FF0000%22%3EDependencies!R9%3C%2FFONT%3E%26amp%3BCHAR(10)%26amp%3BIF(Dependencies!S17%3D%22%22%2C%22%22%2C%3CFONT%20color%3D%22%23FF0000%22%3EDependencies!S9%3C%2FFONT%3E%26amp%3BCHAR(10))%3C%2FFONT%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2749897%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2750048%22%20slang%3D%22en-US%22%3ERE%3A%20Formula%20Question%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2750048%22%20slang%3D%22en-US%22%3EI%20figured%20it%20out.%20I%20just%20needed%20to%20add%20a%20%24%20sign%20before%20the%20Column%20and%20Row.%3C%2FLINGO-BODY%3E
New Contributor

I am trying to drag down a formula but want to keep the false value the same for each cell.  How can I accomplish this?

 

=IF(Dependencies!O17="","",Dependencies!O9&CHAR(10)&IF(Dependencies!P17="","",Dependencies!P9&CHAR(10)&IF(Dependencies!Q17="","",Dependencies!Q9&CHAR(10)&IF(Dependencies!R17="","",Dependencies!R9&CHAR(10)&IF(Dependencies!S17="","",Dependencies!S9&CHAR(10))

1 Reply
I figured it out. I just needed to add a $ sign before the Column and Row.