Dave's Brain

Browse - Computer Tips - How can I use other cells in formulas?

Date: 2014jul28
Product: Microsoft Word

Q.  How can I use other cells in formulas?

A.  There may be other ways to use Word like a spreadsheet but this is how I do it.

- Bookmark any value you want to use later in a calculation.
	Select it.  Then do Insert > Bookmark and pick a reasonable name
	Do not pick name that looks like a cell - eg B7.
	You'll be fine if you only use letters - eg mybookmark

- If you just want another copy of the bookmarked value do:
	Insert Reference > Cross Reference > Bookmark and select the bookmark

- To use the bookmarked value in a calculation do:
	Insert > Field > Formula
	and enter a formula for example:
	
		= mybookmark * 8

Unlike a spreadsheet values don't automatically change when their source does.
Right click and select Update Field.
Or select all with Ctrl-A and press F9.

Add a comment

Sign in to add a comment
Copyright © 2008-2017, dave - Code samples on Dave's Brain is licensed under the Creative Commons Attribution 2.5 License. However other material, including English text has all rights reserved.