pop-up message in spicific cell

  • Thread starter Thread starter cmlm
  • Start date Start date
C

cmlm

I want "message 1" to appear in cell E17 if the value in cell D17 i
smaller than 3 but larger than 2.

"Message 2" must appear in the same cell if the value in cell D17 i
smaller than 1.

Thank you in advance
 
One way


=IF(AND(D17>2,D17<3),"Message 1",IF(AND(D17<>"",D17<1),"Message 2",""))

note that if the value is either 1, 2, 3 or greater than 3 it won't return
anything
if you want include 1, 2 and 3 use

=IF(AND(D17>=2,D17<=3),"Message 1",IF(AND(D17<>"",D17<=1),"Message 2",""))

--


No private emails please, for everyone's
benefit keep the discussion in the newsgroup.

Regards,

Peo Sjoblom
 
Back
Top