**Question description:**

*This user has given permission to use the problem statement for this blog.*

I need the cell to show â??0â? if 3 plus 4 equals and â??1â? 3 plus 4 is either greater than or less than 7â?.

Solved by T. H. in 7 mins

This is the chat thread from the real Excelchat help session. It contains no private user information.

Excelchat Expert
11/05/2018 - 07:10

Hi…Welcome to Got It Pro

User
11/05/2018 - 07:10

hi

Excelchat Expert
11/05/2018 - 07:11

can we do a demo in this blank sheet?

Excelchat Expert
11/05/2018 - 07:12

So if it equals 7 then 0, if it is less or more than 1. Is that correct?

User
11/05/2018 - 07:12

yes

Excelchat Expert
11/05/2018 - 07:13

so 3 & 4 are just variable numbers.

Excelchat Expert
11/05/2018 - 07:13

because 3+4 will always be 7

User
11/05/2018 - 07:13

yeah

Excelchat Expert
11/05/2018 - 07:14

Do you mean to say if you add any 2 variable numbers and the sum is 7 than show 0, otherwise 1?

User
11/05/2018 - 07:14

Its a trick question Ive been asked to solve, so this could be the meaning. I require the formula

Excelchat Expert
11/05/2018 - 07:15

Please look at the formula in C1

Excelchat Expert
11/05/2018 - 07:15

A1 and B1 has your variable numbers. You can change them to see the result in C1

User
11/05/2018 - 07:16

Ok, yes this makes sense

User
11/05/2018 - 07:16

Thank you

Excelchat Expert
11/05/2018 - 07:16

Is there anything else I can help you with this query?

User
11/05/2018 - 07:16

I think this is it. Thanks so much

Excelchat Expert
11/05/2018 - 07:16

Please do give me a good feedback for my service.

Excelchat Expert
11/05/2018 - 07:16

Thanks for your time. Please do come back for any new question. Have a great day ahead!

User
11/05/2018 - 07:16

will do

Excelchat Expert
11/05/2018 - 07:17

Thanks!

Excelchat Expert
11/05/2018 - 07:17

You can end this session now. Thanks again!

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