EXCEL 2007 no longer add properly
Hi,
Did you recalcule the spreadsheet - press F9? If this is the problem, then
choose Tools, Options, Calculation, Automatic
--
Thanks,
Shane Devenshire
"pcor" wrote:
In cell k17 I have the number 1
in cell l17 I have the number 2
in cell m17 I have the formula =+k17+l17(and the answer is 3 as it should be)
Here is the trouble. If I copy cell M17 down to M18 thru m20 I still get the
answer as 3 but there are no number in the k18 and l18 or k19 and l19 or k20
and l20
What has gone wrong?
Thanks
|