IF..THEN..ELSE

Try

=IF(AND(ISBLANK(I2),ISBLANK(X2)),0,IF(ISBLANK(I2),X2,I2))

> =IF(ISBLANK(I2),X2,I2)
> If both I2 and X2 are blank I get 0 (zero)
> What I need is a blank cell
> How do I modify the formula to get the desired results.
> [Any suggestions for a GOOD Excel 2003 book?]

Reply to this Message

Whoops, thought to fast... replace the 0 with "" in the formula.

> =IF(ISBLANK(I2),X2,I2)
> If both I2 and X2 are blank I get 0 (zero)
> What I need is a blank cell
> How do I modify the formula to get the desired results.
> [Any suggestions for a GOOD Excel 2003 book?]

Reply to this Message

=IF(ISBLANK(I2),IF(ISBLANK(X2),"",X2),I2)

MH

> =IF(ISBLANK(I2),X2,I2)
> If both I2 and X2 are blank I get 0 (zero)
> What I need is a blank cell
> How do I modify the formula to get the desired results.
> [Any suggestions for a GOOD Excel 2003 book?]

Reply to this Message

Try this:

=IF(ISBLANK(I2),"",I2)

HTH,
Paul

> =IF(ISBLANK(I2),X2,I2)
> If both I2 and X2 are blank I get 0 (zero)
> What I need is a blank cell
> How do I modify the formula to get the desired results.
> [Any suggestions for a GOOD Excel 2003 book?]

Reply to this Message

PCLIVE - 16 May 2007 22:32 GMT

You really didn't say what your formula is supposed to do. The way you have
it currently written, it says if I2 is blank, then return the value in X2,
otherwise return the value in I2. So why not:

=IF(AND(I2="",X2=""),"",IF(I2="",X2,I2))

HTH,
Paul

> Try this:
>
[quoted text clipped - 8 lines]
>> How do I modify the formula to get the desired results.
>> [Any suggestions for a GOOD Excel 2003 book?]

Reply to this Message

=IF(COUNTA(I2,X2)=0,"",IF(I2="",X2,I2))

> =IF(ISBLANK(I2),X2,I2)
> If both I2 and X2 are blank I get 0 (zero)
> What I need is a blank cell
> How do I modify the formula to get the desired results.
> [Any suggestions for a GOOD Excel 2003 book?]

Reply to this Message

Thanks, everyone, for your reply.
I just found this.
Being new to a discussion group I was not aware of how hard it was to find
my original question until checked and couldn't find it.

It's now in my favorites.

Again, thanks for your replies. They have been extremely helpful.

> =IF(ISBLANK(I2),X2,I2)
> If both I2 and X2 are blank I get 0 (zero)
> What I need is a blank cell
> How do I modify the formula to get the desired results.
> [Any suggestions for a GOOD Excel 2003 book?]

Reply to this Message

JE McGimpsey - 07 Jun 2007 15:59 GMT

> Being new to a discussion group I was not aware of how hard it was to find
> my original question until checked and couldn't find it.

FWIW, it's *much* easier if you use a newsreader instead of a web forum.

Reply to this Message

Strangely, I just got notification on posts to my request.

I have, however, been trying to find my original post off and on for the
last few weeks. I'm new to Discusison Groups and did not note where I had
posted this questions.

I want to thank all of you for getting back to me. This information will be
helpful and doing what I would like to do. Many times I know what I want to
do but can't figure out what MS call it so HELP is not helpful.

Again, thanks for all your repsonses.

> =IF(ISBLANK(I2),X2,I2)
> If both I2 and X2 are blank I get 0 (zero)
> What I need is a blank cell
> How do I modify the formula to get the desired results.
> [Any suggestions for a GOOD Excel 2003 book?]

Reply to this Message