Multiple if functions together

[Dean001]

Hi All,
I've hit a brick wall trying to combine multiple if functions. I am trying to combine the two below functions
=IF(AND(B2>=25,B2<=37,C2>=63,C2<=75),"ALLOY 2","NO MATCH")
=IF(AND(D2>=95),"LAC","NO MATCH")

I want them to look in cells for values that land in a certain range, and then say what that range relates to (Alloy B or LAC, there will be others but they will be basically a copy of this).

Would really appreciate any help with this.

Thanks

 

[Joe4]

How about?

=IF(D2>=95,"LAC",IF(AND(B2>=25,B2<=37,C2>=63,C2<=75),"ALLOY 2","NO MATCH"))

 

[Dean001]

How about?

=IF(D2>=95,"LAC",IF(AND(B2>=25,B2<=37,C2>=63,C2<=75),"ALLOY 2","NO MATCH"))

Wow, Thanks for the really quick response.
That works.
Do you know how I would add in another function eg =IF(AND(R2>=5,R2<=10),"RE-TEST",)
I Can see how yours has worked, but dont know why (not sure if i'm making sense, but am trying to understand it so I can work through it in future.

Thanks

 

[Joe4]

I recommend reading up on "Nested IF" functions. This will demonstrate how these work.
See here: IF function – nested formulas and avoiding pitfalls - Microsoft Support

 

[Dean001]

I recommend reading up on "Nested IF" functions. This will demonstrate how these work.
See here: IF function – nested formulas and avoiding pitfalls - Microsoft Support

Thankyou.
Thats some evening reading sorted