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
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