| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
WHAT ARE REASONS THAT A FORMULA WILL NOT RESPOND TO PRECEDENTS?
I am using a simple addition formula, but its precedents have if and lookup
formulas. the precedents change values correctly but the simple addition formulas do not. If I copy, "paste special" on the precedent cells the addition cells correct and stay that way when I undo the paste. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
WHAT ARE REASONS THAT A FORMULA WILL NOT RESPOND TO PRECEDENTS?
Look to see if your calculations are set to manual under
toolsoptionscalculation, if so change to automatic -- Regards, Peo Sjoblom http://nwexcelsolutions.com "Bizman" wrote in message ... I am using a simple addition formula, but its precedents have if and lookup formulas. the precedents change values correctly but the simple addition formulas do not. If I copy, "paste special" on the precedent cells the addition cells correct and stay that way when I undo the paste. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Match then lookup | Excel Worksheet Functions | |||
| Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
| Creating a check mark box | Setting up and Configuration of Excel | |||
| Match / Vlookup within an Array formula | Excel Discussion (Misc queries) | |||
| I want to trace the precedents in a formula when they are on mult. | Excel Discussion (Misc queries) | |||
Linear Mode
