Look for data entry in cell

J

JBW

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.
 
V

vezerid

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
 
Top