Update on my end...
I found the "T" function under the "Text" category. This will copy the text of the desired cell referenced to, as is into whichever cell you reference it to. In addition, I figured out that if you do an "If" function and declare the desired cell as "If 'cell'>0" and then...