If and or help

[lau05116]

Can some one help me how to write the formula For

If J3= RH170 AND J4= Backhoe AND J5=Electric

Display no1 in D6

OR IF J3=RH170 AND J4=Backhoe AND J5=engine

Display no2 in D6

 

[Darren Bartrup]

Two ways I can think of:

=IF(AND(J3="RH170",J4="Backhoe",J5="Electric"),1,IF(AND(J3="RH170",J4="Backhoe",J5="Engine"),2,""))

or

=IF(AND(J3="RH170",J4="Backhoe"),IF(J5="Electric",1,IF(J5="Engine",2,"")),"")

 

[Ruddles]

=IF(J3&"/"&J4&"/"&J5="RH170/Backhoe/Electric","no1",IF(J3&"/"&J4&"/"&J5="RH170/Backhoe/engine","no2",""))

 

[srikanth58]

Can some one help me how to write the formula For

If J3= RH170 AND J4= Backhoe AND J5=Electric

Display no1 in D6

OR IF J3=RH170 AND J4=Backhoe AND J5=engine

Display no2 in D6

As J3 and J4 are common in both arguments it is sufficient to compare only J5,
Formula in D6
=IF(J5="","",IF(J5="Electric",1,2))

 

[srikanth58]

I am sorry, I think I misread the problem

 

[lau05116]

Both ways sugested just return a blank box no errors come up in the page but also nothing else ideas any1

 

[jlatendre]

Try this?

D6=IF(AND(J3="RH170",J4="Backhoe",J5="Electric"),"no1",IF(AND(J3="RH170",J4="Backhoe",J5="engine"),"no2",""))

Let me know if it works,
Jesse

 

[lau05116]

Try this?

D6=IF(AND(J3="RH170",J4="Backhoe",J5="Electric"),"no1",IF(AND(J3="RH170",J4="Backhoe",J5="engine"),"no2",""))

Let me know if it works,
Jesse

didnt work

 

[jlatendre]

I think you are confusing most people with what you are looking for than, because I tested myn and it seems to work, so can you try to explain a little better for us about what you are looking for.
Thanks,
Jesse

 

[Darren Bartrup]

Tested both my examples - they both worked based on the criteria given:

If J3= RH170 AND J4= Backhoe AND J5=Electric

Display no1 in D6

OR IF J3=RH170 AND J4=Backhoe AND J5=engine

Display no2 in D6

You are putting the formula in cell D6 aren't you?