JakkeJakobsen
Board Regular
- Joined
- Sep 10, 2014
- Messages
- 94
It is a bit more complicated than the title, but it goes for the same.
But more specifically, I want this: If A1 is <2, and B1 is 2>, I want it to give me "Medium". If A1 is 2>, and B1 is 2>, I want it go give me "Closed". If A1 is <2, and B1 is <2, I want it to give me "Open".
Is this possible? It would be like conditional formatting, just that the text changes instead of text or bg color.
But more specifically, I want this: If A1 is <2, and B1 is 2>, I want it to give me "Medium". If A1 is 2>, and B1 is 2>, I want it go give me "Closed". If A1 is <2, and B1 is <2, I want it to give me "Open".
Is this possible? It would be like conditional formatting, just that the text changes instead of text or bg color.