View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Dana DeLouis[_3_] Dana DeLouis[_3_] is offline
external usenet poster
 
Posts: 690
Default 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)