formula doesn't work

  • Thread starter Thread starter rpw
  • Start date Start date
R

rpw

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?
 
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!)
 
Back
Top