View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Terri Terri is offline
external usenet poster
 
Posts: 110
Default Is Cell a formula or a value

I would like to create a formula that will tell me if another cell is a value
or if it contains a formula in it? So for example in cell A2, I want to know
is cell A1 has "=B1+B2" or does it have a 5 in it. I'm assuming it would be
some kind of IF statement, but not sure much beyond that.

thx.