![how to add formulas in word tables how to add formulas in word tables](http://3.bp.blogspot.com/-cQfknF5Ne60/TnaEpJC5A7I/AAAAAAAAAds/2tRtfyFMFHQ/s1600/insert+table+3.jpg)
We could just move the decimal point one place to the left to get our 10% GST, but that would be too easy. No quote or invoice would be complete without our beloved GST. Remember to select the decimal number format, and the popup should look like this :Ĭlick OK and our table should now look like this : With the cursor inside the SUM brackets, type : As before, display the list of available functions, but this time, select SUM. Because Word can’t find any numbers to work with, the popup just shows the equals sign. Ĭlick inside the empty cell in the Total column, go to Layout, Formula. Thus the co-ordinates I need to enter into the formula to add up the three Sub-Total amounts are e2:e4. That honour goes to the column headings I put in. You see, I counted the first row of data as row 1. I didn’t imagine them properly and spent hours trying to work out why my formulas weren’t working. In Word tables, however, we have to imagine those nice, neat co-ordinates. In spreadsheets, the column names and row numbers are always visible, like so : But before we do that I need to explain about co-ordinates. Now we’re going to add up those three numbers, and have Word put the result in the Total column. When you’re done, your table should look like this : Now, as we all know that 500 x 1 = 500, you could just type the next two numbers in the Sub-Total fields, but use Product instead for practice. The number that results from that multiplication will be inserted into the Sub-Total field of the table. Click OK and Word will multiply all the numbers to the left of the current cell until it reaches a blank cell, or, as in our case, it reaches some plain text. While you’re there, click the arrow next to ‘Number format’, scroll down the list and select the decimal format. It will also add two brackets – ( ) – and the cursor will be inside those brackets, ready for you to tell Word which numbers you want multiplied. The one we want is PRODUCT.Ĭlick ‘PRODUCT’ and Word will paste it into the ‘Formula’ box for you. Now click the arrow next to ‘Paste function’ to display the list of available functions. ‘=SUM(LEFT)’ is not the one we want so either backspace over it, or highlight the whole thing and delete. Under Formula, Word automatically displays the formula it thinks you might want to use. Next, click the ‘Layout’ tab at the top of your screen, and select ‘Formula’.
![how to add formulas in word tables how to add formulas in word tables](https://i.ytimg.com/vi/YeLpLKyLgmo/maxresdefault.jpg)
This is what we want to see :Ĭlick inside the Sub-Total cell of Part #123. For this we will need the formula using PRODUCT. The first sum we need to do is to multiply the unit cost of Part #123 by the Unit Qty – i.e. But why whip out the calculator when the table should be able to do the sums for you? Given how few items there are in this table you could easily do the sums in your head and just type them in. So, I created the following table with dummy data : The assumption about the headings is important because it will have an impact later on. I’m further going to assume that most people are like me, and put their headings in the first row – so we know what data to enter where.
HOW TO ADD FORMULAS IN WORD TABLES HOW TO
Okay, I’m going to start with the assumption that most people will know how to create a simple table in Microsoft Word 10.