IF Cell blank, go to next cell

[jalifid11]

I've got 4 cells that I'm trying to reference in a special way.

I've tried using "If" statements, but it will only go so far and then give me an error..

I've got Cell A1, B1, C1, D1..

If cell D1 is blank, return C1, if C1 is blank, return B1, if B1 is blank, return A1. Of course if D1 is not blank, return D1..

I've tried the If statement to replicate this and it does work properly.

HELP !!

 

[mole999]

if D1,C1,B1,A1 all are formula based output,this formula(=IF(D1<>"",D1,IF(C1<>"",C1,IF(B1<>"",B1,A1)))) is not working,pls tell

Please do not dig up old posts for your question (7 years is a bit much). If its new to you, create your own question. Have a read of the forum user guides, it will help you in the long run

 

[newbee7]

Beautiful !
It works great. Simple and to the point, and I am able to copy the syntax and paste into my sheet!
Thank you so much!

 

[newbee7]

MikeRickson:
Beautiful !
It works great. Simple and to the point, and I am able to copy the syntax and paste into my sheet!
Thank you so much