Need correct IF(ISBLANK) formula when referencing whether one of two cells (OR) is blank, returning "no value"

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

insitedge - 15 May 2008 17:09 GMT

=IF(ISBLANK(A1),IF(ISBLANK(B1),"",C1(likely wron formula);

Don't know if I use a comma or OR, or another formula, but if either
A1 or B1 is blank, I want "no value" in C1. If both A1 and B1 have
value then it returns the Value in C1.

Reply to this Message

Gary''s Student - 15 May 2008 17:17 GMT

=IF(OR(A1="",B1=""),"",C1)

Signature

Gary''s Student - gsnu200786

Reply to this Message

Reitanos - 15 May 2008 17:28 GMT

It would work if you add an OR in there:
=IF(OR(ISBLANK(A1),ISBLANK(B1)),"",C1)
but it cannot both put a value in C1 (ie, live there) and check the
value in C1.

> =IF(ISBLANK(A1),IF(ISBLANK(B1),"",C1(likely wron formula);
>
> Don't know if I use a comma or OR, or another formula, but if either
> A1 or B1 is blank, I want "no value" in C1. If both A1 and B1 have
> value then it returns the Value in C1.

Reply to this Message

ND Pard - 15 May 2008 17:30 GMT

Try this:

=IF(OR(ISBLANK(A1),ISBLANK(B1)),"",C1)

Good Luck.

Reply to this Message