Help please!

Trying to write differnet fomulas 1 for Text and 1 for numbers not to
appear if thet aren't in another cell from another worksheet in same
workbook.
Ex 1 is on the first line and this is the current formula
='Piazzo Ware C5"

If there isn't any text, then I the rest of the column should remain
empty and I don't wan tto see the formulas or #VALUE

Ex 2
=e6/e4
this is the current result and I would prefer just an empty cell
instead of "#VALUE!" all over my sheets

Thanks