ExcelBanter - In Excel, how do I identify the contents of a cell as numerical o.

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - In Excel, how do I identify the contents of a cell as numerical o. (https://www.excelbanter.com/excel-discussion-misc-queries/19285-excel-how-do-i-identify-contents-cell-numerical-o.html)

jessica

In Excel, how do I identify the contents of a cell as numerical o.

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?

Ramakrishnan Rajamani

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?

Kassie

=IF(ISTEXT(A1),<Result,<Result)

"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?

All times are GMT +1. The time now is 12:51 PM.