Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
formula to work in a 3-d reference with 2 work books | Excel Worksheet Functions | |||
Formula Won't Work | Excel Discussion (Misc queries) | |||
Sorting the cells of a formula causes the formula to not work | Excel Worksheet Functions | |||
WHY doesn't formula work??? | Excel Discussion (Misc queries) | |||
A search for $ in a formula use to work now it does not work | Excel Discussion (Misc queries) |