Hi Excels,
does anyone have a formula or macro to return a true value if multiple criteria are met, or in this case 2 out of 25 possible matchups.
I have tried the following but it keeps breaking the more criteria I add:
=IF(OR(AND(B2=N6, E2=O6), AND(B2=N6, E2=O5)), "Low", "N/A")(OR(AND(B2=N5, E2=O6), AND(B2=N5, E2=O5)), "Medium", "N/A")
The aim is to return a low, medium or high value if for example criteria "insignificant" in row B2 is matched up with criteria "rare" in row E2, or if criteria "insignificant" in row B2 is matched up with criteria "even chance" in row E2.
Any ideas?
Thanks for your help
does anyone have a formula or macro to return a true value if multiple criteria are met, or in this case 2 out of 25 possible matchups.
I have tried the following but it keeps breaking the more criteria I add:
=IF(OR(AND(B2=N6, E2=O6), AND(B2=N6, E2=O5)), "Low", "N/A")(OR(AND(B2=N5, E2=O6), AND(B2=N5, E2=O5)), "Medium", "N/A")
The aim is to return a low, medium or high value if for example criteria "insignificant" in row B2 is matched up with criteria "rare" in row E2, or if criteria "insignificant" in row B2 is matched up with criteria "even chance" in row E2.
Any ideas?
Thanks for your help