| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Not just True/False | Excel Discussion (Misc queries) | |||
| Search for 2 true arguments and return true or false | Excel Discussion (Misc queries) | |||
| Function to return True/False if all are validated as True by ISNU | Excel Worksheet Functions | |||
| Reverse false and combine with true true value | Excel Worksheet Functions | |||
| True False | Excel Worksheet Functions | |||
Hybrid Mode
