I have added the function to get INPUT value in cell J5 from another Sheet 1.

If there is no value in the Sheet 1 in particular cell, then returns J5 as empty.

So, in this case your function is put the empty code like <caget no = ""/>.

When trying to delete the function from J5 the empty tag is disappeared.

Is there any other way to retain the formula? in cell J5 without put empty code