Look for data entry in cell

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

JBW - 28 Feb 2007 16:27 GMT

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 to this Message

vezerid - 28 Feb 2007 17:05 GMT

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

> 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 to this Message