| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I compare the data in Cell A1 with the data in Cell A2
I know this is probably real simple. I need a way to compare data in cell A1
with data in cell B1 and give me a true / false response in cell C1. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I compare the data in Cell A1 with the data in Cell A2
=IF(A1=B1,TRUE,FALSE)
-- John C "dfwguy" wrote: I know this is probably real simple. I need a way to compare data in cell A1 with data in cell B1 and give me a true / false response in cell C1. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I compare the data in Cell A1 with the data in Cell A2
Maybe a bit shorter
=A1=B1 Mike "John C" wrote: =IF(A1=B1,TRUE,FALSE) -- John C "dfwguy" wrote: I know this is probably real simple. I need a way to compare data in cell A1 with data in cell B1 and give me a true / false response in cell C1. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I compare the data in Cell A1 with the data in Cell A2
Thanks a Million!!
"John C" wrote: =IF(A1=B1,TRUE,FALSE) -- John C "dfwguy" wrote: I know this is probably real simple. I need a way to compare data in cell A1 with data in cell B1 and give me a true / false response in cell C1. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how to find number in a cell , a cell contains character data ornumeric data | Excel Worksheet Functions | |||
| Compare Data on Two Spreadsheets to Put Input Into One Cell | Excel Worksheet Functions | |||
| how to compare cell content to a row pf data in excel and return . | Excel Discussion (Misc queries) | |||
| Using IF statement compare cell ID with data in another column tru | Excel Worksheet Functions | |||
| Compare data - one cell to multiple cells | Excel Discussion (Misc queries) | |||
Linear Mode
