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.