OZmium Sports Betting and Horse Racing Forums

#11

7th August 2006, 06:19 PM

jfc

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

#12

7th August 2006, 06:50 PM

Twodogs

Member

Join Date: Jan 1970

Posts: 221

Okay no problems on the max distance doing what you suggested but on the min distance it tells me there are too many arguments. Not sure what to eliminate.

I have attached my progress

Twodogs

Last edited by Twodogs : 7th August 2006 at 07:00 PM.

#13

7th August 2006, 06:56 PM

jfc

Member

Join Date: Jan 1970

Location: Sydney

Posts: 402

Quote:

Originally Posted by Twodogs

Okay no problems on the max distance doing what you suggested but on the min distance it tells me there are too many arguments. Not sure what to eliminate.

I have attached my progress

Twodogs

=IF(LEN(A2)>3,VALUE(SUBSTITUTE(MID(A2,1+FIND("(",A2),4),")","")),0)

#14

7th August 2006, 07:04 PM

Twodogs

Member

Join Date: Jan 1970

Posts: 221

Thanks JFC

That does it!!! How come it changes from Arial to Verdana font once I insert your formula?? Just interested if there is a reason.
Twodogs

Last edited by Twodogs : 7th August 2006 at 07:11 PM.

#15

7th August 2006, 07:33 PM

jfc

Member

Join Date: Jan 1970

Location: Sydney

Posts: 402

Quote:

Originally Posted by Twodogs

Thanks JFC

That does it!!! How come it changes from Arial to Verdana font once I insert your formula?? Just interested if there is a reason.
Twodogs

Good.

Dunno about your fonts.

Maybe your format has Arial for Text and Verdana for Numbers.

But that's just a guess.

#16

7th August 2006, 07:38 PM

Twodogs

Member

Join Date: Jan 1970

Posts: 221

No problems JFC

Thanks for your help once again

Much Appreciated

Twodogs

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

	To advertise on these forums, e-mail us.