Team,
I am trying to write a formula to look for specific text in two different cells and display "MAINTENANCE".
Example
Look for the text "FALSE" in cell H7 and the text "SHOP" in cell H10. If both have the applicable text, then cell O3 (where I am putting this formula) will read "MAINTENANCE", else, do nothing.
What's the formula for this?
Bookmarks