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

Help Needed for problem with excel asap!

Topic closed. 14 replies. Last post 11 years ago by lottaloot.

Page 1 of 1
PrintE-mailLink
lottaloot's avatar - AvatarZ56
Redford/MI
United States
Member #3396
January 18, 2004
4867 Posts
Offline
Posted: February 24, 2006, 1:57 pm - IP Logged

Don't know what happened, but my calculations for Cell H are going haywire.

where Cell H is =legalT(C2)  it comes back

####

and prior to this, it had been returning the box form of my pick 4 results. 

Can anyone tell why it would do this?????

L ttaL   T

    time*treat's avatar - radar

    United States
    Member #13130
    March 30, 2005
    2171 Posts
    Offline
    Posted: February 24, 2006, 2:22 pm - IP Logged

    lotta,

    in the formula bar, does it say "NAME?" ?

    do/did you have a function called legalT() or just a formula in the cell? 

    you may just need to tell it to recalc. 

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

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

      It says name?  and it's just a formula that I have. 

      It was working fine yesterday. 

      L ttaL   T

        lottaloot's avatar - AvatarZ56
        Redford/MI
        United States
        Member #3396
        January 18, 2004
        4867 Posts
        Offline
        Posted: February 24, 2006, 2:31 pm - IP Logged

        I'm sorry, in the fx bar, it says LegalT(C2) 

        In the cell, it's saying name

        L ttaL   T

          time*treat's avatar - radar

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

          Well, I'd say either recopy the formula from another cell, or try and find your original function "legalT()"., since that's not a built-in one, at least on mine. The spreadsheet is looking for a function called "legalT". Once you find it, you will have to run a recalc.

          The only way I could reproduce this error was to alter my reference style (A1/R1C1).  

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

            time*treat's avatar - radar

            United States
            Member #13130
            March 30, 2005
            2171 Posts
            Offline
            Posted: February 24, 2006, 2:40 pm - IP Logged

            I'm sorry, in the fx bar, it says LegalT(C2) 

            In the cell, it's saying name

            Oh. try changing LegalT(c2) to =LegalT(c2)

             

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

              four4me's avatar - gate1
              MD
              United States
              Member #1701
              June 18, 2003
              8363 Posts
              Offline
              Posted: February 24, 2006, 2:41 pm - IP Logged

              usually when i see these ##### in a cell i have to widen the with of the cell and then i can see the input number.

                lottaloot's avatar - AvatarZ56
                Redford/MI
                United States
                Member #3396
                January 18, 2004
                4867 Posts
                Offline
                Posted: February 24, 2006, 2:48 pm - IP Logged

                Tried that four4me. 

                Will give yours a try time*treat

                L ttaL   T

                  lottaloot's avatar - AvatarZ56
                  Redford/MI
                  United States
                  Member #3396
                  January 18, 2004
                  4867 Posts
                  Offline
                  Posted: February 24, 2006, 2:51 pm - IP Logged

                  Didn't work. 

                  Could this have anything to do with iterations?

                   

                  L ttaL   T

                    time*treat's avatar - radar

                    United States
                    Member #13130
                    March 30, 2005
                    2171 Posts
                    Offline
                    Posted: February 24, 2006, 3:07 pm - IP Logged

                    The trick will be finding out what has changed. Too bad we don't have a "sick spreadsheet" hospital. Drop it off, and pick it up when it's all better.

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

                      lottaloot's avatar - AvatarZ56
                      Redford/MI
                      United States
                      Member #3396
                      January 18, 2004
                      4867 Posts
                      Offline
                      Posted: February 24, 2006, 4:07 pm - IP Logged

                      Just realized that it was a UDF. 

                      Having to reinsert into the module. 

                      Thanks

                      L ttaL   T

                        lottaloot's avatar - AvatarZ56
                        Redford/MI
                        United States
                        Member #3396
                        January 18, 2004
                        4867 Posts
                        Offline
                        Posted: February 24, 2006, 4:39 pm - IP Logged

                        I think it was a freak accident or something. 

                        Had to re-create the pick 4 sheet after re-inserting the user defined function into the module. 

                        Whew!  Cheers 

                        I thought that I was going to pass out cuz it's the only way that I can keep track of all the pick 4's that need to fall still. 

                        L ttaL   T

                          lottaloot's avatar - AvatarZ56
                          Redford/MI
                          United States
                          Member #3396
                          January 18, 2004
                          4867 Posts
                          Offline
                          Posted: February 24, 2006, 4:40 pm - IP Logged

                          Thanks to those that tried to help me in my moment of need. 

                          L ttaL   T

                            time*treat's avatar - radar

                            United States
                            Member #13130
                            March 30, 2005
                            2171 Posts
                            Offline
                            Posted: February 24, 2006, 5:40 pm - IP Logged

                            Ah. That's why I asked if it was a function (what you call a UDF) or a formula. They are handled differently.

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

                              lottaloot's avatar - AvatarZ56
                              Redford/MI
                              United States
                              Member #3396
                              January 18, 2004
                              4867 Posts
                              Offline
                              Posted: February 24, 2006, 5:57 pm - IP Logged

                              Got confused time*treat. 

                              Still learning excel but I love it :=)

                              L ttaL   T