Error with ISBLANK function
=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
|