Excel Help Needed Conditional If I guess

Reply #19

Todd — Sat, 26 Sep 2009 14:53:10 GMT

I just saw this and figured out that his account automatically got tagged by the system when he tried to post a link. New members need to be careful about that, because the system is really good at finding links in posts.

FYI I re-enabled his account so he can get back on so you might want to let him know if you know him.

Reply #18

greeneyes — Thu, 24 Sep 2009 14:06:30 GMT

I checked it out last night .They are the same Thanks for the reply.

Reply #17

CARBOB — Thu, 24 Sep 2009 13:36:45 GMT

Download this file and compare

https://www.lotterypost.com/thread/200626/3

Reply #16

TrueDookie — Thu, 24 Sep 2009 12:21:22 GMT

I haven't talked to Bernie today yet but as of yesterday his account was banned so he couldn't log on to respond.

Reply #15

greeneyes — Wed, 23 Sep 2009 18:23:10 GMT

bernie

look this over

096 LAST DRAW

540 NEXT TO LAST DRAW

444

0 9 9 5 9 14 4 9 13

9 26 35 4 26 30 4 26 30

6 14 20 0 14 14 4 14 18

0 15 15 5 15 20 4 15 19

9 16 25 4 16 20 4 16 20

104 098 100

200 644 548

194 638 542

196 640 544

008 436 340

002 442 346

004 440 344

texas numbers is this correct if it is I will send it out for you.They can email me

Reply #14

centsless — Wed, 23 Sep 2009 17:42:24 GMT

That's terrible. I'm sorry to hear that. I was so waiting for Bernie's updates.

Reply #13

TrueDookie — Wed, 23 Sep 2009 17:31:07 GMT

My friend Bernard Bernie contacted me to tell me his account has been suspended. He got a warning when he tried to post the DL link for the Iznop Excel sheet and then someone suggested he post it in his blog. But it seems posting links in blogs is also prohibited.

Reply #12

budward — Wed, 23 Sep 2009 16:50:46 GMT

Did you try posting the link in your blog

Reply #11

BernieMadoff — Wed, 23 Sep 2009 16:24:59 GMT

I'm having problems responding to pms. If one person sends me an email address to mail it to I will and then you post the link if you are a tenured member. remember i cannot respknd by pm--it's not working most of the time.

Reply #10

radoo9 — Wed, 23 Sep 2009 16:22:04 GMT

Somebody must know how to post your link. ive been reading your posts and cant wait to try this out.

Reply #9

BernieMadoff — Wed, 23 Sep 2009 15:43:03 GMT

IZNOP on Excel is available

Backtest and feel free to be creative with your choice of draws to input.

All you need tro do is put in the last two draws or two draws of your choice Cell A2 and A3.

Everything is done for you--predictions are in column Q.

Pls provide feedback. Improvements and suggestions welcomed. Good luck raking in the Iznop bucks!

****

Sorry I didn't know the rules and was issued an automatic warning about new members posting links. My bad!

Not sure how... [ More ]

Reply #8

txpolo — Tue, 22 Sep 2009 17:42:12 GMT

Thanks, looking forward for your program.

Reply #7

BernieMadoff — Tue, 22 Sep 2009 14:27:56 GMT

That's it I think! Thanks Mickie and Carbob.

Iznop Excel will be available for download later today.

Reply #6

TnTicketlosers — Tue, 22 Sep 2009 14:27:22 GMT

Bernie check your mail

Reply #5

Mickie — Tue, 22 Sep 2009 14:15:55 GMT

IF your number in A2=0

Well then this in your G2:

=MOD(A2+5,10)

will =5

If your numbers are 019

If your numbes are in a2, b2, c2

=MOD(A2+5,10) MOD(B2+5,10) MOD(C2+5,10)

will be 564

Hope this works!

Have a great day

Mickie

Reply #4

CARBOB — Tue, 22 Sep 2009 13:26:40 GMT

enter this in B2 =Mod(A2,5)+1

Reply #3

BernieMadoff — Tue, 22 Sep 2009 12:49:19 GMT

I tried to follow the internal logic but I mustbe missing something.

I wanted the new cell to reflect the following:

If original cell (say A2) had 0, then 5 If A2=1, then 6 and so on...right up to If A2=9, then 4

This is what I tried but somehow it's not working

=IF((OR(A2=0)),5,IF((OR(A2=1)),6,IF((OR(A2=2)),7,IF((OR(A2=3)),8,IF((OR(A2=4)),9,IF((OR(A2=5)),0,IF((OR(A2=6)),1,IF((OR(A2=7)),2,IF((OR(A2=8)),3,IF((OR(A2=9)),4, ))))))))))

I have ten closed parentheses at the end...c... [ More ]

Reply #2

BernieMadoff — Tue, 22 Sep 2009 11:36:20 GMT

Thanks Mickie this was a great help. I am in your debt. You are second in line for a great miracle.

Reply #1

Mickie — Mon, 21 Sep 2009 21:26:04 GMT

Put your number in A2

Put this formula in G2:

=IF((OR(A2=0,A2=5)),1,IF((OR(A2=1,A2=6)),2,IF((OR(A2=2,A2=7)),3,IF((OR(A2=3,A2=8)),4,IF((OR(A2=4,A2=9)),5, )))))

Hope this helps

Mickie

Excel Help Needed Conditional If I guess

BernieMadoff — Mon, 21 Sep 2009 12:47:10 GMT

Note: Hey for the funny folks --speaking of cells --no pun is intended as I am not that other Bernie.

Excel question

How do I get an Excel cell to work out the following

e.g.

If want to be able to let a cell give a value depending on the value of another cell--like vtracs

Assume we have the cell A1

how do I get another cell say G1 to show that if A1 is 5, then G1 will have 0, and if A1 is 4 then G1 is 9 and so on.....don't know if that is conditional if