What are you really trying to do?

A cell can contain either an entered value or a formula, but not both.
However, there are ways using VBA to work around that.

In article ,
"vic_dic" wrote:

Can we have an empty cell but formula embedded in that cell.