If statement
 

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?

If statement
 

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


"ghost" wrote:

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?

If statement
 

Try:

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


"ghost" wrote:

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?

If statement
 

B1: =if(A16000,"Welcome",if(and(A15000,A1<5999),A1," "))

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


"ghost" wrote:

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?

If statement
 

thank you all , it works. intersting