Excel - IF Function Problem - Expert Solution

Question description:
This user has given permission to use the problem statement for this blog.

trying to work out one code for IF I have two numbers 100 and 101 which I want to covert to 111 currently two codes =IF(R6=101,111,IF(R6=100,111)) ideally want one e.g. =IF(R6=101:100,111)
Solved by S. C. in 11 mins
This is the chat thread from the real Excelchat help session. It contains no private user information.
Excelchat Expert 19/12/2017 - 12:42
Hello. Welcome and thank you for choosing Got It Pro Excel.
Excelchat Expert 19/12/2017 - 12:42
I got your query, but I want to clarify some point about it.
User 19/12/2017 - 12:42
ok
Excelchat Expert 19/12/2017 - 12:43
You have two values right?
User 19/12/2017 - 12:43
yes
Excelchat Expert 19/12/2017 - 12:44
100 and 101
User 19/12/2017 - 12:44
yes and I want the IF code to see them and give me 101
User 19/12/2017 - 12:44
sorry 11
User 19/12/2017 - 12:44
111
Excelchat Expert 19/12/2017 - 12:44
If it is 100, it must be converted to 101. And if it is 101, it will be converted to 111.
Excelchat Expert 19/12/2017 - 12:44
Okay.
User 19/12/2017 - 12:45
100 or 101 converted to 111
User 19/12/2017 - 12:45
both coverted
Excelchat Expert 19/12/2017 - 12:45
Please give me a moment to work on it.
User 19/12/2017 - 12:45
cool
Excelchat Expert 19/12/2017 - 12:45
Please hold on. For a while.
Excelchat Expert 19/12/2017 - 12:47
Here is the formula: =IF(OR(A2=100,A2=101),111,"")
Excelchat Expert 19/12/2017 - 12:48
100 or 101, both are converted to 111.
Excelchat Expert 19/12/2017 - 12:48
Did you see it?
User 19/12/2017 - 12:48
no but will watch now
User 19/12/2017 - 12:48
sorry
Excelchat Expert 19/12/2017 - 12:49
Is there something wrong with the output?
User 19/12/2017 - 12:49
i'll try now
User 19/12/2017 - 12:51
thanks - looks perfect
Excelchat Expert 19/12/2017 - 12:51
That's great.
Excelchat Expert 19/12/2017 - 12:51
Do you have question about the functions we used?
User 19/12/2017 - 12:52
nope perfect cheers - I'll come back if I have anymore problems.
Excelchat Expert 19/12/2017 - 12:52
Thank you so much for your cooperation. Please give your honest rating on our service. I hope to have you again in Got It Pro-Excel. Have a good day ahead.
User 19/12/2017 - 12:52
will do and thanks
Excelchat Expert 19/12/2017 - 12:52
Yes. Of course. We are happy to help and serve you.
User 19/12/2017 - 12:53
have a good day
Excelchat Expert 19/12/2017 - 12:53
Same with you. :)

This is the output file from the real Excelchat help session:
This is an example of the expert help you can get. It contains no private user information.

Get instant expert help with Excel and Google Sheets

Post your problem and you’ll get expert help in seconds.

Your message must be at least 40 characters
Your privacy is guaranteed. Your session will not be used for blog unless you give us persmission.