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.
