We will be migrating from Ask to Discourse on the first week of August, read the details here

Ask Your Question

multiply two cells and recalculate if a value is changed? [closed]

asked 2013-08-11 18:28:58 +0200

capetowngraham gravatar image

Ok, absolute newbie to spreadsheets here. I have entered the function (eg: =c1*d1 to display result in e1)which works but if I change a value in one of those C1 or D1 cells, it doesn't update the result cell. Any help much appreciated.

edit retag flag offensive reopen merge delete

Closed for the following reason question is not relevant or outdated by Alex Kemp
close date 2015-11-06 07:37:55.455349

1 Answer

Sort by » oldest newest most voted

answered 2013-08-11 20:01:49 +0200

m.a.riosv gravatar image

Have you Menu/Tools/Cell contents/Autocalculate on?

edit flag offensive delete link more

Question Tools

1 follower


Asked: 2013-08-11 18:28:58 +0200

Seen: 266 times

Last updated: Aug 11 '13