Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Calculatin problem
This just started happening. When I copy a formulae from one cell to another,
the formulae changes the cells correctly but the answer remains the same. Example: I have a formulae that is just adding three columns and putting the result in the 4th column - so the formulae is simple "=sum(a2+b2+d2)" with the result going in e2. So when I copy the formulae from e2 to e3 the formulae changes to a3,b3 and d3 but the result is the same exact result as in e2. The puzzle to me is this worked correctly just a couple of days ago, what has changed? More importantly how to fix it -- Larry |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Calculatin problem
Tools Options Calculation select Automatic
"Larry" wrote: This just started happening. When I copy a formulae from one cell to another, the formulae changes the cells correctly but the answer remains the same. Example: I have a formulae that is just adding three columns and putting the result in the 4th column - so the formulae is simple "=sum(a2+b2+d2)" with the result going in e2. So when I copy the formulae from e2 to e3 the formulae changes to a3,b3 and d3 but the result is the same exact result as in e2. The puzzle to me is this worked correctly just a couple of days ago, what has changed? More importantly how to fix it -- Larry |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Calculatin problem
Standard answer number 1:
Tools/ Options/ Calculation Set it to Automatic, not Manual. Oh, and "formulae" is a plural word; if it's only one of them it's a formula. :-) -- David Biddulph "Larry" wrote in message ... This just started happening. When I copy a formulae from one cell to another, the formulae changes the cells correctly but the answer remains the same. Example: I have a formulae that is just adding three columns and putting the result in the 4th column - so the formulae is simple "=sum(a2+b2+d2)" with the result going in e2. So when I copy the formulae from e2 to e3 the formulae changes to a3,b3 and d3 but the result is the same exact result as in e2. The puzzle to me is this worked correctly just a couple of days ago, what has changed? More importantly how to fix it -- Larry |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
"How do enter formula for multiple labour rates when calculatin p. | Excel Discussion (Misc queries) | |||
Started out as an Access problem. Now an Excel problem | Excel Discussion (Misc queries) | |||
Calculatin NPV for a range of numbers. | Excel Worksheet Functions | |||
problem with a conditional max problem | Excel Discussion (Misc queries) |