I am trying to use the IF command to return a certain response if the value is contained in a list. For example if I have a list containing the numbers 1, 2, 3, and 4 and then I have a cell with a "5" in it. I want to create a formula that says look at the cell containing the 5 and if it is in my list return a "1" or else return a "0". I have tried many different approaches but have not been successful. Any ideas? Thanks.
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Using IF to find a value in a list
- Thread starter beckery1
- Start date
Scott Huish
MrExcel MVP
- Joined
- Mar 17, 2004
- Messages
- 20,373
- Office Version
- 365
- Platform
- Windows
Cool. I like that one, I'll have to remember that 
Upvote
0
Excel Facts
Round to nearest half hour?
Use =MROUND(A2,"0:30") to round to nearest half hour. Use =CEILING(A2,"0:30") to round to next half hour.
PA HS Teacher
Well-known Member
- Joined
- Jul 17, 2004
- Messages
- 2,838
What is the significance of the &""
How does this change/modify the results of --Isnumber() ?
How does this change/modify the results of --Isnumber() ?
Upvote
0
Scott Huish
MrExcel MVP
- Joined
- Mar 17, 2004
- Messages
- 20,373
- Office Version
- 365
- Platform
- Windows
If you append a string onto the end of a number, it becomes text, in this case Aladin is appending an empty string onto the end of the number to change it to text.
Upvote
0
Similar threads
- Question
