Help Needed for problem with excel asap!Prev TopicNext Topic

• lottaloot

  

  Redford/MI
  United States
  Member #3,396
  January 18, 2004
  4,867 Posts
  Offline
  Feb 24, 2006, 1:57 pm

  ▲▼

  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

  

  United States
  Member #13,130
  March 30, 2005
  2,171 Posts
  Offline
  Feb 24, 2006, 2:22 pm

  ▲▼

  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

  

  Redford/MI
  United States
  Member #3,396
  January 18, 2004
  4,867 Posts
  Offline
  Feb 24, 2006, 2:24 pm

  ▲▼

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

  It was working fine yesterday. 

  L ttaL   T
• lottaloot

  

  Redford/MI
  United States
  Member #3,396
  January 18, 2004
  4,867 Posts
  Offline
  Feb 24, 2006, 2:31 pm

  ▲▼

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

  In the cell, it's saying name

  L ttaL   T
• time*treat

  

  United States
  Member #13,130
  March 30, 2005
  2,171 Posts
  Offline
  Feb 24, 2006, 2:37 pm

  ▲▼

  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

  

  United States
  Member #13,130
  March 30, 2005
  2,171 Posts
  Offline
  Feb 24, 2006, 2:40 pm

  ▲▼
  Quote: Originally posted by lottaloot on February 24, 2006

  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

  

  MD
  United States
  Member #1,701
  June 18, 2003
  10,731 Posts
  Offline
  Feb 24, 2006, 2:41 pm

  ▲▼

  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

  

  Redford/MI
  United States
  Member #3,396
  January 18, 2004
  4,867 Posts
  Offline
  Feb 24, 2006, 2:48 pm

  ▲▼

  Tried that four4me. 

  Will give yours a try time*treat

  L ttaL   T
• lottaloot

  

  Redford/MI
  United States
  Member #3,396
  January 18, 2004
  4,867 Posts
  Offline
  Feb 24, 2006, 2:51 pm

  ▲▼

  Didn't work. 

  Could this have anything to do with iterations?

   

  L ttaL   T
• time*treat

  

  United States
  Member #13,130
  March 30, 2005
  2,171 Posts
  Offline
  Feb 24, 2006, 3:07 pm

  ▲▼

  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

  

  Redford/MI
  United States
  Member #3,396
  January 18, 2004
  4,867 Posts
  Offline
  Feb 24, 2006, 4:07 pm

  ▲▼

  Just realized that it was a UDF. 

  Having to reinsert into the module. 

  Thanks

  L ttaL   T
• lottaloot

  

  Redford/MI
  United States
  Member #3,396
  January 18, 2004
  4,867 Posts
  Offline
  Feb 24, 2006, 4:39 pm

  ▲▼

  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!   

  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

  

  Redford/MI
  United States
  Member #3,396
  January 18, 2004
  4,867 Posts
  Offline
  Feb 24, 2006, 4:40 pm

  ▲▼

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

  L ttaL   T
• time*treat

  

  United States
  Member #13,130
  March 30, 2005
  2,171 Posts
  Offline
  Feb 24, 2006, 5:40 pm

  ▲▼

  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

  

  Redford/MI
  United States
  Member #3,396
  January 18, 2004
  4,867 Posts
  Offline
  Feb 24, 2006, 5:57 pm

  ▲▼

  Got confused time*treat. 

  Still learning excel but I love it :=)

  L ttaL   T