Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I'm using the IF function to check for 'something' in a cell before
calculating a formula. Trouble is I need it to check that there has been an entry in the cell, not a number. I need it to look in the cell and say there's been an entry put into it, whether it's zero or greater, but not look as a number rather as data. |
#2
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Please rephrase. What do you mean "an entry, not a number"? What do
you mean "not look as number rather as data?" Do you by any chance mean that the cell contains a formula rather than a constant value? Do you mean it should contain text and not a number? Please be specific about your condition. HTH Kostis Vezerides On Feb 28, 6:27 pm, JBW wrote: I'm using the IF function to check for 'something' in a cell before calculating a formula. Trouble is I need it to check that there has been an entry in the cell, not a number. I need it to look in the cell and say there's been an entry put into it, whether it's zero or greater, but not look as a number rather as data. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Cell Entry That Locks Selected Cells From Any Data Entry. | Excel Worksheet Functions | |||
Data entry - Copy contents of cell typed in one cell to another ce | Excel Worksheet Functions | |||
Blocking entry of data in a cell | Excel Worksheet Functions | |||
data in cell not corresponding with entry | New Users to Excel | |||
Using a ComboBox for Data Entry into a Cell | Excel Worksheet Functions |