Help to resolve last value

[torrev07]

Hi to all,
I’m tried to make a formula to get the last value acomulative in cels from B thru E. This is the formula and the result that I obtain is 0.

=if(E2<>””,E2,if(D2<>””,D2,if(C2<>””,C2,B2)))

The last value is in Cel D and it’s supposed to be 3.

Value in Cel B is 1, Cel C is 2 and Cel D is 3.

What I need to fix in the formula?

Thank you

 

[Eric W]

Try

=LOOKUP(9E+307,B2:E2)


Your original formula looks OK, except for using ”” instead of "".

 

[torrev07]

Thanks Eric, I have the correct “”. It’s because I write by my phone lol.

 

[Eric W]

I figured it was something like that, I've seen it before, I thought I'd mention it just in case. Other than that, the formula looks fine, if it still doesn't work, check to see if the range references are correct.