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!)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Same formulas, but one returns a #DIV/0! error 7
Excel keeps copying formulas into other cells!! 2
Excel does not calculate my formulas 13
Dragging/Copying Formulas in Excel 2007 3
Expanding Date formula 1
No formulas Work 3
Qualifying a generated value as unique across worksheets 3
F9 Calc refresh does not work... 3

Back
Top