7th August 2006, 06:19 PM
|
|
Member
|
|
Join Date: Jan 1970
Location: Sydney
Posts: 402
|
|
Quote:
|
Originally Posted by Twodogs
Hi JFC
Worked it out. For the min dist
=IF(LEN(A2)>3,CONCATENATE(SUBSTITUTE(MID(A2,1+FIND("(",A2),4),")","")," "),"0")
and max dist
=IF(LEN(A2)>3,CONCATENATE(SUBSTITUTE(LEFT(RIGHT(A2,5),4),"(","")),"0")
Now when I apply =IF(AND(B1>=C1,B1<=D1),"yes","no") I get no for all results but if I remove the formulas ( copy and paste special values only) I get yes and no where applicable. JFC what do I need to do so I don't have to remove the formulas from the min and max dist columns?
Twodogs
|
You seem to be getting there
My guess is the results you are getting are text. They need to be numbers.
So replace the CONCATENATE (which you no longer actually need) with VALUE and the rightmost "0" with 0 and then you should have numbers |