Error with ISBLANK function

[Dave]

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

 

[Bob Umlas]

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

 

[Stefi]

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

Regards,
Stefi

„Dave†ezt írta:

 

[MartinW]

Hi Dave,

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

HTH
Martin