Sep 14 2021 09:41 AM
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))
Sep 14 2021 10:27 AM