| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
If statement
thank you all , it works. intersting |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| appending and IF statement to an existing IF statement | Excel Worksheet Functions | |||
| I need help with an "If" Statement | Excel Worksheet Functions | |||
| If statement | Excel Worksheet Functions | |||
| If statement and Isblank statement | Excel Worksheet Functions | |||
| Help please, IF statement/SUMIF statement | Excel Worksheet Functions | |||
Linear Mode
