**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.*