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
  #21  
Old 26th April 2006, 08:19 AM
Twodogs Twodogs is offline
Member
 
Join Date: Jan 1970
Posts: 221
Default

Thanks La Mer

Just looking at it now. Might be able to use that as well.

Beauty
Twodogs
Reply With Quote
  #22  
Old 26th April 2006, 08:25 AM
Twodogs Twodogs is offline
Member
 
Join Date: Jan 1970
Posts: 221
Default

Any hints for if I want within that formula to say Q7>22 and less than 35.

=IF(AND(O7<2.5,Q7>22OR<35.2,U7>0),1,0) wouldn't work would it??

Twodogs
Reply With Quote
  #23  
Old 26th April 2006, 09:22 AM
Twodogs Twodogs is offline
Member
 
Join Date: Jan 1970
Posts: 221
Default

=IF(AND(O7<2.5,((Q7>22)*OR(Q7<35.2,))*U7>0),1,0)
This seems to work but it was a solution offered by excel itself. I don't understand how it works. Can someone explain please?

Thanks
Twodogs
Reply With Quote
  #24  
Old 26th April 2006, 01:30 PM
La Mer La Mer is offline
Member
 
Join Date: Jan 1970
Posts: 578
Default

Quote:
Originally Posted by Twodogs
=IF(AND(O7<2.5,((Q7>22)*OR(Q7<35.2,))*U7>0),1,0)
This seems to work but it was a solution offered by excel itself. I don't understand how it works. Can someone explain please? Thanks Twodogs


What exactly are you attempting to achieve Twodogs?
Reply With Quote
  #25  
Old 26th April 2006, 01:36 PM
Twodogs Twodogs is offline
Member
 
Join Date: Jan 1970
Posts: 221
Default

Howdy La Mer

I have 3 columns with data in and a fourth I want to put either 1 or 0 in if the other 3 columns have all got the the correct data I am after.

I am looking for the following in the 3 columns

column 1 must be less than 2.5
column 2 must be between 22 and 35.3
column 3 must be greater than 0

If all agree I get a 1 in column 4 if not 0

Twodogs
Reply With Quote
  #26  
Old 26th April 2006, 02:47 PM
La Mer La Mer is offline
Member
 
Join Date: Jan 1970
Posts: 578
Default

Quote:
Originally Posted by Twodogs
Howdy La Mer

I have 3 columns with data in and a fourth I want to put either 1 or 0 in if the other 3 columns have all got the the correct data I am after.

I am looking for the following in the 3 columns

column 1 must be less than 2.5
column 2 must be between 22 and 35.3
column 3 must be greater than 0

If all agree I get a 1 in column 4 if not 0

Twodogs


Try this: =IF(A1<2.5,IF(B1>=22,IF(B1<=35.3,IF(C1>0,1,0)),0),0)

I've done a quick test & it appears to work OK. No need for the AND statement. Best of luck.
Reply With Quote
  #27  
Old 26th April 2006, 02:53 PM
Twodogs Twodogs is offline
Member
 
Join Date: Jan 1970
Posts: 221
Default

Thanks La Mer

The other formula I posted works but I would rather understand how it works.Will have a play thanks for your help today La Mer

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:24 AM.


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