software

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, quot;paste specialquot; on the precedent cells the
addition cells correct and stay that way when I undo the paste.

Look to see if your calculations are set to manual under
toolsgt;optionsgt;calculation, if so change to automatic--

Regards,

Peo Sjoblom

nwexcelsolutions.com

quot;Bizmanquot; gt; wrote in message
...
gt;I am using a simple addition formula, but its precedents have if and lookup
gt; formulas. the precedents change values correctly but the simple addition
gt; formulas do not. If I copy, quot;paste specialquot; on the precedent cells the
gt; addition cells correct and stay that way when I undo the paste.