True false function for alpha data
I'm trying to write a formula that gives me a true/false outcome...
One additional idea might be:
=EXACT(A1,B1)
One difference is that if the strings are
80E & 80e, then Exact() would return False.
= = = =
Dana DeLouis
On 11/17/09 3:36 PM, R Y wrote:
Row # Column1 Column2 Outcome
1 80E 80E TRUE
2 999 80E FLASE
3 80E 80E TRUE
4 CB1 80E FALSE
5 80E 80E TRUE
6 999 80E FALSE
7 999 C76 FALSE
I'm trying to write a formula that gives me a true/false outcome for the
above data and the results would be where the outcome is located (completed
manualy)
|