Excel 'Proper' Formula

scaeagles · 03-27-2005, 04:42 PM

I'm pretty well versed in Excel, and I guess I'm confused as to how you can get a circular reference using "proper".

That is one hell of a big spreadsheet.

Can you tell me what you've typed in the specific cell that gives you the circular reference?

BarTopDancer · 03-27-2005, 04:49 PM

Ya, it's a huge spreadsheet. It was given to us in all CAPS which is harsh on the eyes. We're also confused as to how we're getting a circular reference.

I know I tried:

=proper(A1:E220000)
=proper(A1:A220000)
=proper (A1:E1)

I can't recall which one gave the circular reference (most likely the first), and tracing of the reference doesn't show us the error.

03-27-2005, 04:42 PM	#1
scaeagles I LIKE! Join Date: Jan 2005 Posts: 7,819	I'm pretty well versed in Excel, and I guess I'm confused as to how you can get a circular reference using "proper". That is one hell of a big spreadsheet. Can you tell me what you've typed in the specific cell that gives you the circular reference?
	Submit to Quotes

03-27-2005, 04:49 PM	#2
BarTopDancer Prepping... Join Date: Jan 2005 Location: Here, there, everywhere Posts: 11,405	Ya, it's a huge spreadsheet. It was given to us in all CAPS which is harsh on the eyes. We're also confused as to how we're getting a circular reference. I know I tried: =proper(A1:E220000) =proper(A1:A220000) =proper (A1:E1) I can't recall which one gave the circular reference (most likely the first), and tracing of the reference doesn't show us the error. __________________ Spork is the new MacGyver Postcards From My Edge
	Submit to Quotes