Formula Question

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