Ask Your Question
1

Spreadsheet problem with filling down formulas [closed]

asked 2012-07-25 20:46:57 +0200

anonymous user

Anonymous

updated 2015-10-17 03:37:57 +0200

Alex Kemp gravatar image

Am Using 3.4.4 version When I use "fill>down" or drag down to copy formulas in a table, the formula changes correctly, but the number shown is incorrect. the new cells show the same number that was in the first cell.

I can get the correct number if I retype the formula into each cell, but that a pain since I have many cells with the same formula.

Thanks for any help you can give.

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2015-10-17 03:38:06.095092

1 Answer

Sort by » oldest newest most voted
0

answered 2012-07-25 21:25:21 +0200

m.a.riosv gravatar image

The result change after recalculation, press F9,

some functions need a hard recalculation Ctrl+Shift+F9.

You can activate the automatic calculation in: Menu/Tools/CellContents/Autocalculate.

edit flag offensive delete link more

Question Tools

Stats

Asked: 2012-07-25 20:46:57 +0200

Seen: 1,434 times

Last updated: Jul 25 '12