View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
JBW JBW is offline
external usenet poster
 
Posts: 42
Default 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.