Welcome Guest
Log In | Register )
You last visited December 9, 2016, 10:18 am
All times shown are
Eastern Time (GMT-5:00)

Excel formula's....help needed

Topic closed. 12 replies. Last post 11 years ago by powerplayer.

Page 1 of 1
PrintE-mailLink
powerplayer's avatar - Lottery-022.jpg

United States
Member #17834
June 28, 2005
2083 Posts
Offline
Posted: January 13, 2006, 3:30 pm - IP Logged

I know there has been so many post on excel....

Well either way..Here is my question:

I have the following formula:

=SUM(ISNUMBER(FIND(C69,$B$3:$AF$54))*1)

Every time I use the ctrl + shift + enter it just stays with the formula in the cell???

It use to give me the results and now when I add new formula anywhere even in a fully new excel sheet it still does it..

Any one know how to fix this or what I'm doing wrong all of a sudden??

This has been a halt to working on my program and is driving me crazy!! It's been like this for almost a week..

Any help/input would be great!!

Thanks

PP

Good luck to everyone!!!

    lottaloot's avatar - AvatarZ56
    Redford/MI
    United States
    Member #3396
    January 18, 2004
    4867 Posts
    Offline
    Posted: January 13, 2006, 3:50 pm - IP Logged

    It provided me with a number when I copied it into my sheet. 

    Has it been working well for you in the past? 

     

    L ttaL   T

      CARBOB's avatar - FL LOTTERY_LOGO.png
      ORLANDO, FLORIDA
      United States
      Member #4924
      June 3, 2004
      5907 Posts
      Online
      Posted: January 13, 2006, 4:13 pm - IP Logged

      PP,

       The formula works for me. Sounds like you have a format problem.

      Carbob

        time*treat's avatar - radar

        United States
        Member #13130
        March 30, 2005
        2171 Posts
        Offline
        Posted: January 13, 2006, 8:09 pm - IP Logged

        power,

        click on Tools --> Options --> View 

        look under "window options", uncheck "formulas"  

        In neo-conned Amerika, bank robs you.
        Alcohol, Tobacco, and Firearms should be the name of a convenience store, not a govnoment agency.

          powerplayer's avatar - Lottery-022.jpg

          United States
          Member #17834
          June 28, 2005
          2083 Posts
          Offline
          Posted: January 14, 2006, 3:46 am - IP Logged

          power,

          click on Tools --> Options --> View 

          look under "window options", uncheck "formulas"  

          thank you all for the help...so far no luck still.

          I tried the uncheck formulas but, I didn't have that checked.

          It's a weird problem....if no one else is getting just the formula after hitting the ctrl shift enter...then I don't know myself..what went wrong..???

          If I open up a brand new excel sheet...and I'm at work it still doesn't work for me...I know I'm hitting the right keys..togeather...

          Maybe a one of the macro/scripts I did caused this...I'm going to have to dive in to this and work at it..

          Thanks again for the help...

          if anyone can come up with any other idea's of why this is happening...let me know...

           

          PP

          Good luck to everyone!!!

            Avatar
            Anna, TX
            United States
            Member #26720
            November 21, 2005
            263 Posts
            Offline
            Posted: January 14, 2006, 4:57 am - IP Logged

            do you have auto calculate turned off in options?

            that may be it.  

              powerplayer's avatar - Lottery-022.jpg

              United States
              Member #17834
              June 28, 2005
              2083 Posts
              Offline
              Posted: January 14, 2006, 6:10 am - IP Logged

              do you have auto calculate turned off in options?

              that may be it.  

              it was on the default of auto...

              I haven't changed anything...I'm baffled on this...thx for the help hareless

              PP

              Good luck to everyone!!!

                Avatar
                Anna, TX
                United States
                Member #26720
                November 21, 2005
                263 Posts
                Offline
                Posted: January 14, 2006, 6:45 am - IP Logged

                well then sacrifice chickens on the keyboard then.

                  time*treat's avatar - radar

                  United States
                  Member #13130
                  March 30, 2005
                  2171 Posts
                  Offline
                  Posted: January 14, 2006, 2:37 pm - IP Logged

                  power,

                  I'm using XL97. I c&p this formula into a new sheet.
                  It merged 24 cells and gave me "0". After the unmerge, it put "0" into cell A1
                  What is the purpose of the ctrl +shift + enter sequence? Never used that one.
                  Maybe you could send someone a copy of the offending sheet.
                  We're trying to diagnose why your car is acting funny, while you imitate the noise it's making... over the phone Shocked

                  When I copy it directly into the formula bar, it gives me an error message and highlights $B$3. I would compare this to an older working version, character by character. I once spent the better part of a day frantically searching for an error that turned out to be a 1 letter difference in variable names.

                  In neo-conned Amerika, bank robs you.
                  Alcohol, Tobacco, and Firearms should be the name of a convenience store, not a govnoment agency.

                    hypersoniq's avatar - 8ball
                    Pennsylvania
                    United States
                    Member #1340
                    April 6, 2003
                    2450 Posts
                    Offline
                    Posted: January 14, 2006, 8:17 pm - IP Logged

                    if you get unexpected errors in excel that have no particular reason, this might help...

                    close excel and use windows search to find a file called

                    normal.dot

                    when you do, delete it

                    restart excel and this file will be regenerated automatically, it is a configuration file. (templates, I believe)

                    I have seen this fix the strangest errors...

                    Playing more than one ticket per game is betting against yourself.

                      hypersoniq's avatar - 8ball
                      Pennsylvania
                      United States
                      Member #1340
                      April 6, 2003
                      2450 Posts
                      Offline
                      Posted: January 14, 2006, 8:19 pm - IP Logged

                      all about CSE (control+shift+enter) formulas...

                      http://www.mrexcel.com/tip011.shtml

                       

                      Playing more than one ticket per game is betting against yourself.

                        powerplayer's avatar - Lottery-022.jpg

                        United States
                        Member #17834
                        June 28, 2005
                        2083 Posts
                        Offline
                        Posted: January 15, 2006, 3:49 am - IP Logged

                        power,

                        I'm using XL97. I c&p this formula into a new sheet.
                        It merged 24 cells and gave me "0". After the unmerge, it put "0" into cell A1
                        What is the purpose of the ctrl +shift + enter sequence? Never used that one.
                        Maybe you could send someone a copy of the offending sheet.
                        We're trying to diagnose why your car is acting funny, while you imitate the noise it's making... over the phone Shocked

                        When I copy it directly into the formula bar, it gives me an error message and highlights $B$3. I would compare this to an older working version, character by character. I once spent the better part of a day frantically searching for an error that turned out to be a 1 letter difference in variable names.

                        Hi time treat,

                        What is the purpose of the ctrl +shift + enter sequence? Never used that one.

                        Mainly it's for a array formula or from what I can see when you make formula on your own that is not in excel you have to hit these 3 keys to make excel accept it.

                        Check out the link that was given it explain what it means.

                        PP

                        Good luck to everyone!!!

                          powerplayer's avatar - Lottery-022.jpg

                          United States
                          Member #17834
                          June 28, 2005
                          2083 Posts
                          Offline
                          Posted: January 15, 2006, 6:12 pm - IP Logged

                          hello all...I found the fix for my problem. I wen to help and did a auto fix/repair in the help options. I have excel 2000 or office pro.

                          Thank you all that helped out.

                          Looking to create new formula of counting digits in a split pair form.

                          Example: 123 this would be set up like

                          123 in one cell then next to it would be the formula that take that # in the cell and counts 1x3 just the 1 & 3 and puts the out put in that cell with a count of best split pairs.

                          The formula I have now =SUM(ISNUMBER(FIND(BY26,$B$3:$AF$22))*1)

                          Counts the whole # combination. So I figue I just need to know how I would put a spacer inbetween BY26 which is the loaction of the cell with the combination you want to put the pair off of. This will leave the middle # for use to use a hot digit or cold digit out for that postion.

                          There maybe a thread with this..not sure.haven't found one yet..but, there is a lot of threads on here.

                          If someone knows of one..if you can post a link that would be great!!

                          Thanks again to all the help

                          PP

                           

                           

                          Good luck to everyone!!!