=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