Look for data entry in cell
 

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.

Look for data entry in cell
 

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.