View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Dave Dave is offline
external usenet poster
 
Posts: 1,388
Default Error with ISBLANK function

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