You can have a formula or you can have some text. Can't be both at the same
time, although a formula may generate text.

Tell us more about what needs to be in that cell during different situations
and maybe we can work out a solution.

"Smitha Roney" wrote:

How do I insert a formula in a cell,which contains some text