Hi,

2 options. The first looks for an empty string in A1 and the second looks
for a blank cell

=IF(A1="","My first formula","My other formula")
=IF(ISBLANK(A1),"My first formula","My other formula")

Mike

"rexmann" wrote:

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