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