Problem with ISBLANK function

[davehunter]

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

[VBA Noob]

Maybe

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

VBA Noob

[NBVC]

Try:

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

if only one of those cells is filled and the others are always blank and the cell(s) are numeric.... then, =Sum(B49:D49) may suffice?

[davehunter]

seems like =IF(ISBLANK(D1),IF(ISBLANK(C1),B1,C1),D1) is the formula i need.

however, i now need to do this from column M to B. is there a quicker way of doing this, or do I need to write it all out by hand?

thanks, dave!

[VBA Noob]

Would last in Col work

http://www.xldynamic.com/source/xld....l#last_numeric

VBA Noob

[davehunter]

Would last in Col work

http://www.xldynamic.com/source/xld....l#last_numeric

VBA Noob

Hi VBA Noob,

Could you advise which of the formulas on this page would allow me to find the last value between columns B and M i.e. furthest right (towards M).

Thanks
Dave

[VBA Noob]

Click on any of the links. The top formula shows by row the other by column.

Choose the column one and adjust your range

VBA Noob