Welcome Guest
You last visited October 24, 2017, 7:24 am
All times shown are
Eastern Time (GMT-5:00)

Help Needed for problem with excel asap!

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

 Page 1 of 1
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

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.

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

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

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.

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.

MD
United States
Member #1701
June 18, 2003
8577 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.

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

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

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.

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

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!

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

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

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.

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

 Page 1 of 1