find difference

sksanjeev786

Well-known Member
Joined
Aug 5, 2020
Messages
884
Office Version
  1. 365
  2. 2016
Platform
  1. Windows
Hi Team,

I have a statement looks similar but while performing true or false condition I getting false can I get the diff. from both the cells

Book1
B
6Q062. If you were applying for a new credit card, how would this ad affect your consideration of Capital One? Q101. How strongly do you agree or disagree that what the ad puts across about Capital One is believable? Q102. How much new information does the ad give you about Capital One? Q100. If you were applying for a new credit card, how relevant would the points made in the ad be to you?
7Q062. If you were applying for a new credit card, how would this ad affect your consideration of Capital One? Q101. How strongly do you agree or disagree that what the ad says or shows about Capital One is believable? Q102. How much new information does the ad give you about Capital One? Q100. If you were applying for a new credit card, how relevant would the points made in the ad be to you?
8
9FALSE
Sheet1
Cell Formulas
RangeFormula
B9B9=B6=B7


Thanks
Sanjeev
 

Excel Facts

Round to nearest half hour?
Use =MROUND(A2,"0:30") to round to nearest half hour. Use =CEILING(A2,"0:30") to round to next half hour.
is it ok for me to ask to make this thread answered by my formula or is it against some regulations?

if you can able to explain your formula step by step we will be happy to learn those things and will share this with my team as well.

Even I got the step-by-step formula from another team so I believe we can do it here.

But yes it's up to you no force on this :)

Happy to use your formulaaaaa:)

Regards,
Sanjeev.
 
Upvote 0

Forum statistics

Threads
1,215,328
Messages
6,124,299
Members
449,149
Latest member
mwdbActuary

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top