Joined: Feb 18, 2007 Posts: 239 Location: LaLaLand
Posted: Wed Aug 01, 2007 12:05 am Post subject:
If you follow this thread from a previous post; titled Linked cells
I believe it will answer one part of your question; linking cells from Sheet 1 to Sheet 2; as for updating the formula already in place; the link I've posted has more links to user guides and manuals
I'm just checking here, but your post says you want Sheet1 A1 to contain the result of Sheet1 A1 + Sheet2 A1 and that's not possible, to have Sheet1 A1 refer to its own contents.
If you want Sheet1 B1 (for example) to contain the result, the formula would be =A1+Sheet2.A1 - but unless the value in Sheet1 A1 is itself already a formula, you can't get the result in that cell. If Sheet1 A1 is a formula, then you can just add +Sheet2.A1 to the formula.
Note that the syntax differs from Excel, which would be Sheet2!A1.
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum You cannot attach files in this forum You cannot download files in this forum