If statement

[ghost]

I have cells a1 and b2, what I want to do is if the value in a1 smaller than
5000 the b1 will be blank, else grater than 5000 or smaller than 5999 b1=
value of a1, else grater than 6000 b1="welcome"
How can I do that please?

 

[Teethless mama]

=IF(A1<5000,"",IF(A1<6000,A1,"welcome"))

 

[JMB]

Try:

=CHOOSE(LOOKUP(A1,{0,5000,6000},{1,2,3}),"",A1,"welcome")

 

[Barb Reinhardt]

B1: =if(A1>6000,"Welcome",if(and(A1>5000,A1<5999),A1,""))

I'm not sure what you want if A1 = 6000, right now you get a blank

 

[ghost]

thank you all , it works. intersting