View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
R Y R Y is offline
external usenet poster
 
Posts: 1
Default True false function for alpha data

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)