Forum Discussion
SLGiguere
Sep 25, 2023Copper Contributor
Excel - Return a specific text value, based on values of 2 other cells
Hello, I would be grateful if someone could help with a formula to accomplish the following: Based on combinations of the text values in cells A2 and B2, I would like C2 to return a specific text...
SergeiBaklan
Sep 25, 2023Diamond Contributor
Your sample is translated literally
=IF( AND( A2= "Low", B2 = "Low" ), "Monitor", "have no idea what to be in other cases")