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

IF blank!!
 

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

IF blank!!
 

Hi Mike

Nice one, worked as it says.

Just for the record (anyohe else reading the post) I used the ISBLANK function

Cheers Rexmann

"Mike H" wrote:

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

IF blank!!
 

Why would you use =if(isblank(a1), ... instead of =if(a1="",....

Just curious.

rexmann wrote:

Hi Mike

Nice one, worked as it says.

Just for the record (anyohe else reading the post) I used the ISBLANK function

Cheers Rexmann

"Mike H" wrote:

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



--

Dave Peterson

IF blank!!
 

He'd need to do it that way if he were trying to distinguish between a truly
empty cell and one that might have an empty string returned by a formula.
--
David Biddulph

"Dave Peterson" wrote in message
...
Why would you use =if(isblank(a1), ... instead of =if(a1="",....

Just curious.

rexmann wrote:

Hi Mike

Nice one, worked as it says.

Just for the record (anyohe else reading the post) I used the ISBLANK
function

"Mike H" wrote:

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")

"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

IF blank!!
 

I'm still curious if that's the distinction that the OP wanted.

David Biddulph wrote:

He'd need to do it that way if he were trying to distinguish between a truly
empty cell and one that might have an empty string returned by a formula.
--
David Biddulph

"Dave Peterson" wrote in message
...
Why would you use =if(isblank(a1), ... instead of =if(a1="",....

Just curious.

rexmann wrote:

Hi Mike

Nice one, worked as it says.

Just for the record (anyohe else reading the post) I used the ISBLANK
function

"Mike H" wrote:

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")

"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

--

Dave Peterson

IF blank!!
 

The OP referred to both Blank and Empty which is why both were provided.

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

Mike

"Dave Peterson" wrote:

I'm still curious if that's the distinction that the OP wanted.

David Biddulph wrote:

He'd need to do it that way if he were trying to distinguish between a truly
empty cell and one that might have an empty string returned by a formula.
--
David Biddulph

"Dave Peterson" wrote in message
...
Why would you use =if(isblank(a1), ... instead of =if(a1="",....

Just curious.

rexmann wrote:

Hi Mike

Nice one, worked as it says.

Just for the record (anyohe else reading the post) I used the ISBLANK
function

"Mike H" wrote:

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")

"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

--

Dave Peterson

IF blank!!
 

I wasn't curious why you provided both answers. That made sense to me.


Mike H wrote:

The OP referred to both Blank and Empty which is why both were provided.

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

Mike

"Dave Peterson" wrote:

I'm still curious if that's the distinction that the OP wanted.

David Biddulph wrote:

He'd need to do it that way if he were trying to distinguish between a truly
empty cell and one that might have an empty string returned by a formula.
--
David Biddulph

"Dave Peterson" wrote in message
...
Why would you use =if(isblank(a1), ... instead of =if(a1="",....

Just curious.

rexmann wrote:

Hi Mike

Nice one, worked as it says.

Just for the record (anyohe else reading the post) I used the ISBLANK
function

"Mike H" wrote:

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")

"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

--

Dave Peterson


--

Dave Peterson

IF blank!!
 

Hi Mike, and anyone else reading this.

This formula is exactly what I'm looking for - except I can't get it to work
properly.

My formula is:

=IF(B5="","=MAX(C5-D5+E5,0)","=MIN(B5+D5-E5)")

So, if C5 is blank, run the first formula which shows the positive value of
certain cells, or run the other formula which shows the negative value of
other cells.

However instead of getting a value the text just shows in the cell.

What am I doing wrong?

Thanks
Susan

"Mike H" wrote:

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

IF blank!!
 

The problem is you put quote marks around the formulas (turning them into
pure text) and, after you remove the quote marks, you will also have to
remove the equal signs (the only equal sign needed to tell Excel what
follows is a formula is the leading equal sign)...

=IF(B5="",MAX(C5-D5+E5,0),MIN(B5+D5-E5))

Rick


"susann" wrote in message
...
Hi Mike, and anyone else reading this.

This formula is exactly what I'm looking for - except I can't get it to
work
properly.

My formula is:

=IF(B5="","=MAX(C5-D5+E5,0)","=MIN(B5+D5-E5)")

So, if C5 is blank, run the first formula which shows the positive value
of
certain cells, or run the other formula which shows the negative value of
other cells.

However instead of getting a value the text just shows in the cell.

What am I doing wrong?

Thanks
Susan

"Mike H" wrote:

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