The Financial Reporting Toolkits Formula Builder for MS Word is an add-in program that makes it easy to create formulas in Microsoft Word! A new menu added to the core Word program lets you create formulas in any new or existing Word document. Formula Builder feature - Word does not provide cell addresses in its core program. You have to figure out the cell address manually by counting the number of columns and rows. In smaller tables this isnt too difficult, albeit inconvenient. However, it can be a challenge in larger tables. If you miscount the columns or rows, youll also get erroneous results. Word makes it impractical to use formulas, so most people dont. Formula Builder solves these problems. Formula Builder is a wizard that walks you through the steps of building a formula. Click on the cell address you want in your formula and Formula Builder automatically determines the cell address for you. If you need to add a range of cells using the SUM function just select the range and Formula Builder will compute the correct cell range address for you. The wizard includes easy access to any of Words eighteen built in functions. Copy and Paste Table Formula feature - This is one of the most exciting features of the program. Excel automatically updates cell addresses in copied formula for their relative references. Words core copy and paste functions simply duplicate formulas as written, resulting in erroneous calculations. The programs Copy and Paste Table Formula function solves this problem. Select the cell containing the formula you want to copy and click the Copy Table Formula button. Select a cell or a range of cells you want to copy the formula to and click the Paste Table Formula button. The formula cell addresses will be automatically updated for relative references.
