Thread: If statement
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
ghost ghost is offline
external usenet poster
 
Posts: 41
Default 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?