G Guest Mar 22, 2004 #1 I want to display a text message in one cell when another cell hits a vaule ie 0 to 3 text would read good 3 to 9 bad
I want to display a text message in one cell when another cell hits a vaule ie 0 to 3 text would read good 3 to 9 bad
A Andy B Mar 22, 2004 #2 Hi Try =IF(AND(A1>=0,A1<=3),"Good",IF(AND(A1>3,A1<=9),"Bad","")) Andy keeny said: I want to display a text message in one cell when another cell hits a Click to expand... vaule ie 0 to 3 text would read good 3 to 9 bad
Hi Try =IF(AND(A1>=0,A1<=3),"Good",IF(AND(A1>3,A1<=9),"Bad","")) Andy keeny said: I want to display a text message in one cell when another cell hits a Click to expand... vaule ie 0 to 3 text would read good 3 to 9 bad
