IF blank!!

R

rexmann

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
 
M

Mike H

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
 
R

rexmann

Hi Mike

Nice one, worked as it says.

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

Cheers Rexmann
 
D

Dave Peterson

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

Just curious.
 
D

David Biddulph

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.
 
M

Mike H

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
Click to expand...

Mike
 
S

susann

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
 
R

Rick Rothstein \(MVP - VB\)

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
 
Top