Hi,

I'm trying to achieve the following:

In Cell A49 I want to have a value from D49. But if D49 is blank, I want the
value from C49, but if C49 is blank I want the value from B49.

=IF(ISBLANK(D49),((ISBLANK(C49),(B49),(C49),)),D49 )

is what I have come up with but it doesn't seem to be correct. Can someone
please show me where I've gone wrong.

Thanks!
Dave

=IF(ISBLANK(D49),IF(ISBLANK(C49),B49,C49),D49)
Bob Umlas
Excel MVP

"Dave" wrote in message
...
Hi,

I'm trying to achieve the following:

In Cell A49 I want to have a value from D49. But if D49 is blank, I want
the
value from C49, but if C49 is blank I want the value from B49.

=IF(ISBLANK(D49),((ISBLANK(C49),(B49),(C49),)),D49 )

is what I have come up with but it doesn't seem to be correct. Can someone
please show me where I've gone wrong.

Thanks!
Dave

=IF(ISBLANK(D49),IF(ISBLANK(C49),B49,C49),D49)

Regards,
Stefi

€žDave€� ezt Ã*rta:

Hi,

I'm trying to achieve the following:

In Cell A49 I want to have a value from D49. But if D49 is blank, I want the
value from C49, but if C49 is blank I want the value from B49.

=IF(ISBLANK(D49),((ISBLANK(C49),(B49),(C49),)),D49 )

is what I have come up with but it doesn't seem to be correct. Can someone
please show me where I've gone wrong.

Thanks!
Dave

Hi Dave,

Try this,
=IF(D49<"",D49,IF(C49<"",C49,B49))

HTH
Martin


"Dave" wrote in message
...
Hi,

I'm trying to achieve the following:

In Cell A49 I want to have a value from D49. But if D49 is blank, I want
the
value from C49, but if C49 is blank I want the value from B49.

=IF(ISBLANK(D49),((ISBLANK(C49),(B49),(C49),)),D49 )

is what I have come up with but it doesn't seem to be correct. Can someone
please show me where I've gone wrong.

Thanks!
Dave