Yahoo Answers is shutting down on May 4th, 2021 (Eastern Time) and beginning April 20th, 2021 (Eastern Time) the Yahoo Answers website will be in read-only mode. There will be no changes to other Yahoo properties or services, or your Yahoo account. You can find more information about the Yahoo Answers shutdown and how to download your data on this help page.
Trending News
Is there a formula to check multiple cells in Excel?
I've tried using the "exact" formula but that seems to limit me to only two cells. I have three columns and about 1,000 rows and my eyeballs are about to burn out. So far I can only use the exact formula to check two of the three then in another cell compare the remainder. An easier way? Thanks!
I have three columns - each cell containing a number from three difference sources. I need to check for any discrepancies. I want to add a formula on the side that will give me a true or false result if the numbers match (or don't)
3 Answers
- 1 decade agoFavorite Answer
=IF(AND(A1=B1,B1=C1),TRUE, FALSE)
...should do the trick. Just drag & copy that formula down as far as you need to.
You could then put this formula at the bottom of the TRUE / FALSE column to indicate how many rows are true or false.
=COUNTIF(D1:D1000,TRUE) - Will count the true cells, and...
=COUNTIF(D1:D1000,FALSE) - Will count the false cells.
You can email me if you wish.
Andrew
- Anonymous1 decade ago
Try hitting the autosum button.
- Anonymous1 decade ago
Hi,
sorry but i do not understand the question, what are you checking for ??? can you please give some more info please.
