Formula stopped working

[mtntgr]

Hi,

1st time ever, a formula pasted throughout a column stopped working.
#VALUE! "A value used in the formual is the wrong data type."
=IF(O25="","",((F25+G25+I25+O25)+R25+Q24))
works in preceding 20 cells...
checked all cell formatting, maybe I'm tired but can't find it....
Is it possible for a worksheet to get corrupted like this?

Any suggestions much appreciated.

Thanks,
Ken

 

[mtntgr]

Posting spreadsheets

Is it possible to post part of spreadsheet to forum?

 

[Richard Schollar]

Hi Ken

Use Colo's html maker to post your sheet - see the link in my signature.

Best regards

Richard

 

[mtntgr]

Colo snapshot

MY_2006_Casino Directory.xls
	F	G	H	I	J	K	L	M	N	O	P	Q	R
23					$160.00	$8.00	20	$2.50	-98.44%	($157.50)	($497.37)	$1,507.25
24					$100.00	$5.00	20	$124.25	24.25%	$24.25	$121.25	$1,531.50
25					$100.00	$5.00	20	$21.00	-79.00%	($79.00)	($215.45)	$1,452.50	<??
26					$40.00	$2.00	20	$100.00	150.00%	$60.00	$44.44	$1,512.50
27					$100.00	$5.00	20	$200.00	100.00%	$100.00	$84.51	$1,612.50
ERROR

 

[mtntgr]

after wrestling with various install issues this neat program (colo's...) is working- although, I have to acknowledge an error (1004) mulitple times before it will open up webpage with snapshot...

R25 (which was originally "<<???") points to Q25-
where I had to "break" the code and start fresh to keep Column Q working.
Not the most elegant soultion, but it works for now...

I am puzzled!

Thanks
Ken

 

[mtntgr]

by the way L23 should be:
=IF(N(J23),J23/K23,"")

Don't know why Colo is showing #s in ColA instead of formulas...

 

[mtntgr]

just realized that I25 contained a formula that shouldn't have been there (due to link line in Colo snapshot)
removed it but it didn't help

gremlins!

 

[Richard Schollar]

Ken

What's in R25? In Colo's sheet as posted it isn't blank.

Richard

 

[mtntgr]

Just a text- reminder to myslef that Q25 is where it stopped working...

 

[mtntgr]

Now its working!?

MY_2006_Casino Directory.xls
	F	G	H	I	J	K	L	M	N	O	P	Q	R
25					$100.00	$5.00	20	$21.00	-79.00%	($79.00)	($215.45)	$1,452.50
26					$40.00	$2.00	20	$100.00	150.00%	$60.00	$44.44	$1,512.50
27					$100.00	$5.00	20	$200.00	100.00%	$100.00	$84.51	$1,612.50
28		$11.82	ADJ.		$160.00	$8.00	20	$162.00	1.25%	$2.00	$1.82	$1,626.32
ERROR