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

 

[Joe4]

I think you need to explain in more detail, as your request does not make much sense (or is missing some very important detail).
Formulas cannot "go" anywhere. They simply return a value to whatever cell are they located in.
Are you looking for VBA code to go to (select) a certain cell? If so, what is triggering this VBA code to run?
Will it be done manually, or automatically upon some event happening.

 

[jacobrcotton]

Nested IF Statement?

If(NOT(or(A1=0, A1="")), A1, if(NOT(or(B1=0,B1="")), b1, if(NOT(or(C1.....

however, you can only nest 6 if statements (i think its 6?) so if you have more than 6, you may need to run a group of 6, then another group of 6, then a group of 2 to combine them. or another solution entirely.

 

[DGuidry]

No VBA. Hopefully a simple formula. I'm trying to cascade an answer to see what's in a railcar. A1 is the product, B1 is the last contained and C1 is the business group. So if there is no data for product, then use last contained. But is there is no data data for last contained, use business group.

 

[DGuidry]

Nested IF Statement?

If(NOT(or(A1=0, A1="")), A1, if(NOT(or(B1=0,B1="")), b1, if(NOT(or(C1.....

however, you can only nest 6 if statements (i think its 6?) so if you have more than 6, you may need to run a group of 6, then another group of 6, then a group of 2 to combine them. or another solution entirely.

No, I'm only looking at 3 statements. I'm familiar with and and or, but not NOT. Okay, I'll give it a try. Thanks.

 

[Joe4]

Perhaps you have just worded the question poorly.
Do you really mean "return the value from" instead of "go to"?

Can you show us some sample data, spanning the range of possibilities, and your expected results?

 

[DGuidry]

I think you need to explain in more detail, as your request does not make much sense (or is missing some very important detail).
Formulas cannot "go" anywhere. They simply return a value to whatever cell are they located in.
Are you looking for VBA code to go to (select) a certain cell? If so, what is triggering this VBA code to run?
Will it be done manually, or automatically upon some event happening.

No VBA. Hopefully a simple formula. I'm trying to cascade an answer to see what's in a railcar. A1 is the product, B1 is the last contained and C1 is the business group. So if there is no data for product, then use last contained. But is there is no data data for last contained, use business group.

 

[DGuidry]

Perhaps you have just worded the question poorly.
Do you really mean "return the value from" instead of "go to"?

Can you show us some sample data, spanning the range of possibilities, and your expected results?

Correct. return value from.

 

[Joe4]

Correct. return value from.

Then try this:

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

 

[DGuidry]

Correct. return value from.

In another column, I want to know what is in UTLX683877. If there is no current Product, I want to use the Last Contained. If there is no Last Contained, I want to use the Business Group. This should be some sort of nested IF statement formula, but I can't make it work.