"Task Lead Nicole" wrote in
message ...
I've learned how to create a formula that will insert a word/text into a
cell
if its linked data is NOT NULL (from another worksheet)... but can I
differentiate between code/formulas and text in that cell?


Do you mean NOT BLANK?

In other words, the source cell has formula for a link from yet another
worksheet, so my worksheet cell reads that that cell is NOT NULL even
though
there's no text in it.

A cell with a formula is not blank; but you can use IF to return "". Then
change your formula to look for anything but "" before it proceeds -- i.e.,
IF(A1<"",C1+A1,"").