Welcome Guest
You last visited January 23, 2017, 5:30 am
All times shown are
Eastern Time (GMT-5:00)

Excel Help Needed Conditional If I guess

Topic closed. 19 replies. Last post 7 years ago by Todd.

 Page 1 of 2

United States
Member #78317
August 12, 2009
92 Posts
Offline
 Posted: September 21, 2009, 8:47 am - IP Logged

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

Spring Lake
United States
Member #313
April 26, 2002
181 Posts
Offline
 Posted: September 21, 2009, 5:26 pm - IP Logged

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

Mickie

United States
Member #78317
August 12, 2009
92 Posts
Offline
 Posted: September 22, 2009, 7:36 am - IP Logged

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

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

United States
Member #78317
August 12, 2009
92 Posts
Offline
 Posted: September 22, 2009, 8:49 am - IP Logged

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...can anyone see what i am doing wrong?

ORLANDO, FLORIDA
United States
Member #4924
June 3, 2004
5981 Posts
Offline
 Posted: September 22, 2009, 9:26 am - IP Logged

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

Spring Lake
United States
Member #313
April 26, 2002
181 Posts
Offline
 Posted: September 22, 2009, 10:15 am - IP Logged

Well then this in your G2:
=MOD(A2+5,10)
will =5

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

Mickie

United States
Member #71120
February 19, 2009
1209 Posts
Offline
 Posted: September 22, 2009, 10:27 am - IP Logged

United States
Member #78317
August 12, 2009
92 Posts
Offline
 Posted: September 22, 2009, 10:27 am - IP Logged

Well then this in your G2:
=MOD(A2+5,10)
will =5

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

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

United States
Member #173
April 8, 2002
6114 Posts
Offline
 Posted: September 22, 2009, 1:42 pm - IP Logged

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

Thanks, looking forward for your program.

WTG all Winner\$.

United States
Member #78317
August 12, 2009
92 Posts
Offline
 Posted: September 23, 2009, 11:43 am - IP Logged

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 to get around this--I don't want a whole lot of people sending me pms and sending out pms to everyone.

scarborough maine
United States
Member #59137
March 7, 2008
69 Posts
Offline
 Posted: September 23, 2009, 12:22 pm - IP Logged

United States
Member #78317
August 12, 2009
92 Posts
Offline
 Posted: September 23, 2009, 12:24 pm - IP Logged

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.

United States
Member #33295
February 19, 2006
699 Posts
Offline
 Posted: September 23, 2009, 12:50 pm - IP Logged

Isabel, you are going to feel very silly when this turns out to be make-believe.

Hanover, NH
United States
Member #57393
January 3, 2008
21 Posts
Offline
 Posted: September 23, 2009, 1:31 pm - IP Logged

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.

TX/LOTTOLAND/USA
United States
Member #78380
August 13, 2009
2679 Posts
Offline
 Posted: September 23, 2009, 1:42 pm - IP Logged

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

 Page 1 of 2