formula doesn't work
 

This is a strange one. Using Office 07. Create simple formula:
=C23-G23 (Returns 00.0 when itshould be 175.00)

When Formula Options is set to manual, the formula works. When set to
Automatic, it doesn't.

Is there some other setting prohibiting the formula from working properly?

--
rpw

formula doesn't work
 

OK, figured it out. The spreadsheet had several circular references in it
and after I tracked down and corrected those, the formula worked. Thanks all
(for all your previous help!)
--
rpw


"rpw" wrote:

This is a strange one. Using Office 07. Create simple formula:
=C23-G23 (Returns 00.0 when itshould be 175.00)

When Formula Options is set to manual, the formula works. When set to
Automatic, it doesn't.

Is there some other setting prohibiting the formula from working properly?

--
rpw