 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / October 2006uk lotto dream numbers
hello again, can some one hlep with this formula, =IF(AND($B$4=B7,$C$4=C7,$D$4=D7,$E$4=E7,$F$4=F7,$G$4=G7),"!! JACKPOT !!",IF(AND($B$4=B7,$C$4=C7,$D$4=D7,$E$4=E7,$F$4=F7),"1st 5 Balls",IF(AND($B$4=B7,$C$4=C7,$D$4=D7,$E$4=E7),"1st 4 Balls",IF(AND($B$4=B7,$C$4=C7,$D$4=D7),"1st 3 Balls",if(and($b$4=b7,$c$4=c7,"1st 2 Balls","")))) its to check looto cells $b$4 to $g$4 agains my ticket b7 to g7 dont know if everyone knows how the lotto dream numbers works but you must match a minimum of 1st 2 numbers to win so answers can only be 1st 2 balls, 1st 3 balls , 1st 4 balls, 1st 5 balls , jackpot theres probably an easyer way to do the samething but i aint got a clue on it... where row 7 is your numbers and row 5 is the winning numbers will give the number of matches for for 7 =IF(G7=0,"",SUMPRODUCT(COUNTIF(B7:F7,$B$5:$F$5)))  SignatureDon Guillett SalesAid Software dguillett1@austin.rr.com > hello again, can some one hlep with this formula, > [quoted text clipped - 13 lines] > theres probably an easyer way to do the samething but i aint got a clue on > it... sorry don not what i'm after. yur formula returns the correct number of balls, but in order to win you must have the balls in correct order. b5 to g5 = 10,28,30,34,36,40 b7 to g7 = 8,27,30,34,36,40 your formula returns 4 in this case i need it to match the 1st 2 numbers to give a result so if b7 to g7 = 10,28,30,35,38,40 would = 3 numbers where as b7 to g7 = 9,28,30,35,38,40 would = nothing also b7 to g7 = 10,27,30,34,36,40 would = nothing hope this helps , dunno if i've made it more complicated now but i can still use your formula to tidy up anther thing i've got going so many thanks for that > where row 7 is your numbers and row 5 is the winning numbers will give the > number of matches for for 7 [quoted text clipped - 17 lines] > > theres probably an easyer way to do the samething but i aint got a clue on > > it... try this idea for 3 matches =IF((B5&C5&D5)=($B$4&$C$4&$D$4),3,if(etc) SignatureDon Guillett SalesAid Software dguillett1@austin.rr.com > sorry don not what i'm after. yur formula returns the correct number of > balls, but in order to win you must have the balls in correct order. [quoted text clipped - 36 lines] >> > on >> > it... Thats the one .. Cheers Don works a treat > try this idea for 3 matches > [quoted text clipped - 39 lines] > >> > on > >> > it... glad to help. I quit playing the Texas Lotto a couple of years ago but I had a rather involved workbook to keep track. I do custom work. SignatureDon Guillett SalesAid Software dguillett1@austin.rr.com > Thats the one .. Cheers Don works a treat > [quoted text clipped - 43 lines] >> >> > on >> >> > it... I'm guessing the one person that can afford to play lotto (Mr. Gates) doesn't! Why do you suppose that is??? > glad to help. I quit playing the Texas Lotto a couple of years ago but I had > a rather involved workbook to keep track. I do custom work. [quoted text clipped - 46 lines] > >> >> > on > >> >> > it... Gee, and I always thought that was how he got his start! SignatureDon Guillett SalesAid Software dguillett1@austin.rr.com > I'm guessing the one person that can afford to play lotto (Mr. Gates) > doesn't! Why do you suppose that is??? [quoted text clipped - 56 lines] >> >> >> > on >> >> >> > it... Heck ... I thought he got his start from robbin ... er, I mean using the GUI from Xerox!<bg> SignatureRegards, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- > > Gee, and I always thought that was how he got his start! [quoted text clipped - 58 lines] > >> >> >> > on > >> >> >> > it... |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.