Smartgambler
Pro-Punter

Go Back   OZmium Sports Betting and Horse Racing Forums > Public Forums > General Topics
User Name
Password
Register FAQ Search Today's Posts Mark all topics as read

To advertise on these
forums, e-mail us.

Reply
 
Thread Tools Search this Thread Display Modes
  #11  
Old 7th August 2006, 06:19 PM
jfc jfc is offline
Member
 
Join Date: Jan 1970
Location: Sydney
Posts: 402
Default

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
Reply With Quote
  #12  
Old 7th August 2006, 06:50 PM
Twodogs Twodogs is offline
Member
 
Join Date: Jan 1970
Posts: 221
Default

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.
Reply With Quote
  #13  
Old 7th August 2006, 06:56 PM
jfc jfc is offline
Member
 
Join Date: Jan 1970
Location: Sydney
Posts: 402
Default

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)
Reply With Quote
  #14  
Old 7th August 2006, 07:04 PM
Twodogs Twodogs is offline
Member
 
Join Date: Jan 1970
Posts: 221
Default

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.
Reply With Quote
  #15  
Old 7th August 2006, 07:33 PM
jfc jfc is offline
Member
 
Join Date: Jan 1970
Location: Sydney
Posts: 402
Default

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.
Reply With Quote
  #16  
Old 7th August 2006, 07:38 PM
Twodogs Twodogs is offline
Member
 
Join Date: Jan 1970
Posts: 221
Thumbs up

No problems JFC

Thanks for your help once again

Much Appreciated

Twodogs
Reply With Quote
Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is On
Forum Jump



All times are GMT +10. The time now is 08:01 PM.


Powered by: vBulletin Version 3.0.3
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
©2008 OZmium Pty. Ltd. All rights reserved . ACN 091184655