ExcelBanter - True/False Comparison

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - True/False Comparison (https://www.excelbanter.com/excel-discussion-misc-queries/188198-true-false-comparison.html)

Randy

True/False Comparison

I have column A and Column B populated with dates. Through a formula, In
column C, i want to indicate "true" if the two dates are the same and
"false" if the two dates are different.

Bob I

True/False Comparison

If(a1=b1,"True","False")

Randy wrote:

I have column A and Column B populated with dates. Through a formula, In
column C, i want to indicate "true" if the two dates are the same and
"false" if the two dates are different.

FSt1

True/False Comparison

hi
=if(A2=B2,"True","False")

regards
FSt1

"Randy" wrote:

I have column A and Column B populated with dates. Through a formula, In
column C, i want to indicate "true" if the two dates are the same and
"false" if the two dates are different.

Randy

True/False Comparison

Thanks, works perfectly!

"Bob I" wrote:

If(a1=b1,"True","False")

Randy wrote:

I have column A and Column B populated with dates. Through a formula, In
column C, i want to indicate "true" if the two dates are the same and
"false" if the two dates are different.

Randy

True/False Comparison

Thanks, works perfectly!

"FSt1" wrote:

hi
=if(A2=B2,"True","False")

regards
FSt1

"Randy" wrote:

I have column A and Column B populated with dates. Through a formula, In
column C, i want to indicate "true" if the two dates are the same and
"false" if the two dates are different.

David Biddulph[_2_]

True/False Comparison

=A2=B2
--
David Biddulph

"Randy" wrote in message
...
I have column A and Column B populated with dates. Through a formula, In
column C, i want to indicate "true" if the two dates are the same and
"false" if the two dates are different.

All times are GMT +1. The time now is 10:59 PM.