Thread: IF blank!!
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
rexmann rexmann is offline
external usenet poster
 
Posts: 79
Default IF blank!!

Hi All

I have an IF statement which I want to identify if it has a blank cell or not.
So I do one formula if it is empty and one if it has a value

I have managed to do it with multiple columns using =istext but I want the
formula all in one cell. I have tried if cell=null and variations but can't
crack it.

Any suggestions? any help greatly appreciated

Rexmann
PS using excel 2003