Help for multiple conditions

[DGuidry]

I need help to create a formula in Excel with multiple conditions. So if cell A1 is blank or zero, go to B1, else A1. However, if B1 is also blank or zero go to C1, else B1.

Thanks

 

[DGuidry]

Then try this:

=IF(OR(A1="",A1=0),IF(OR(B1="",B1=0),C1,B1),A1)

It looks like that worked. Thank you very much!

 

[jacobrcotton]

bouncing off Joe's formula, you'd want something like

=if(or(K1="", K1=0), if(or(L1="", 0), J1, L1), K1)

EDIT: glad you got it solved!

 

[Joe4]

You are welcome.
Glad we were able to help!

 

[Peter_SSs]

It looks like that worked. Thank you very much!

The marked solution has been changed accordingly. In your future questions, please mark the post as the solution that actually answered your question, instead of your feedback message as it will help future readers. No further action is required for this thread.