IF..THEN..ELSE

S

sos-DC

=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?]
 
P

PCLIVE

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


PCLIVE said:
Try this:

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

HTH,
Paul

sos-DC said:
=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?]
Click to expand...
Click to expand...
 
S

sos-DC

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

JE McGimpsey

sos-DC said:
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.
Click to expand...

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

sos-DC

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