Welcome Guest
Log In | Register )
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
PrintE-mailLink
Avatar

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

    Mickie's avatar - Lottery-008.jpg
    Spring Lake
    United States
    Member #313
    April 26, 2002
    181 Posts
    Offline
    Posted: September 21, 2009, 5:26 pm - IP Logged

    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

    MickieDisney

      Avatar

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

      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

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

        Avatar

        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?

          CARBOB's avatar - FL LOTTERY_LOGO.png
          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

            Mickie's avatar - Lottery-008.jpg
            Spring Lake
            United States
            Member #313
            April 26, 2002
            181 Posts
            Offline
            Posted: September 22, 2009, 10:15 am - IP Logged

            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

            MickieDisney

              TnTicketlosers's avatar - Lottery-065.jpg

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

              Bernie check your mail

                Avatar

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

                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

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

                 

                Iznop Excel will be available for download later today.

                  txpolo's avatar - animaniacs16

                  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.

                   

                  Iznop Excel will be available for download later today.

                  Thanks, looking forward for your program.Smiley

                   BananaWTG all Winner$. Hyper

                   

                   

                    Avatar

                    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.

                    Any suggestions. The file is ready for download on 4shared.

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

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

                        Avatar

                        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.

                          Avatar

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

                          Did you try posting the link in your blog?

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

                            Avatar
                            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.

                              centsless's avatar - animal butterfly.jpg
                              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.