=(Cell) formula does not work

[Guest]

I accidentally had a circular reference, and it probably hosed the worksheet

In Cell J4 is a calculated value that equals 100. In cell J5 is a calculated value that displays as zero

In cell J6 I enter the formula =J4 and it displays zero

In cell J7 I enter the formula =1-J5 amd it equals 0

If I enter in =(Cell) for a non-calculated value, I get the proper display

So according to excell 1 - 0 = 0 or simplifying the mathematics 1 = 0. This is different than the math I learned in the first grade

Is there any way to restore sanity to this worksheet?

 

[Bob Phillips]

Sorry but I don't believe you are giving accurate or detailed facts. I know
that Excel does not think that 1 = 0.

Where is the circular reference? Does the worksheet still have it?

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

I accidentally had a circular reference, and it probably hosed the worksheet.

In Cell J4 is a calculated value that equals 100. In cell J5 is a

calculated value that displays as zero.

In cell J6 I enter the formula =J4 and it displays zero.

In cell J7 I enter the formula =1-J5 amd it equals 0.

If I enter in =(Cell) for a non-calculated value, I get the proper display.

So according to excell 1 - 0 = 0 or simplifying the mathematics 1 = 0.

This is different than the math I learned in the first grade.