| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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? |
|
#2
|
|||
|
|||
|
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? |
|
#3
|
|||
|
|||
|
=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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel to Excel, Cut & Paste, 1 cell, text, multiplies file size f. | Excel Discussion (Misc queries) | |||
| Can I use the contents of a cell to satisfy the result_vector arg. | Excel Worksheet Functions | |||
| Adding contents of one cell to a range of cells. | Excel Worksheet Functions | |||
| Paste rows of numbers from Word into single Excel cell | Excel Discussion (Misc queries) | |||
| GET.CELL | Excel Worksheet Functions | |||
Linear Mode
