Try =Istext(Cell) and =Isnumber(cell) respectively.

"jessica" wrote:

In excel, I am trying to use the IF formula to put out a value, depending on
whether the cell has text or a numerical value. How can I identify the
contents of a cell as text or numeric using a formula?