It is not necessary that all the tables that we create or calculations that we perform are in Excel. We can add a formula to tables in Microsoft Outlook to an email and it is much easier than you imagine.
There are many uses for formulas in tables in Outlook. We can do several things: send final grades to a student, total sales for the month to an employee, recall emails received from a customer, etc. Basically, we can use them for whatever we imagine or need.
How to insert a table in Microsoft Outlook
In case we already have the data table configured in the email , you can skip this guide to go directly to the one dedicated to adding the formula. In case you haven’t added a table yet and don’t know how to do it, then read on.
Once we are in the mail window, we will have to go to the “Insert” tab and then click on the “Table” drop-down box. We will have to drag the boxes to be able to establish the number of columns and rows that we need and then we simply click to insert the table in question.
Alternatively we can choose “Insert table” in the drop-down list and enter the number of rows and columns that we want to add to the email, we can also configure the way the table is adjusted. Then we click on “OK” and that’s it.
How to add a formula to tables in Outlook
We already have our table added to the content of the email, it is time to add the formula and for this, we will have to click inside the cell where we want to add said formula.
Next, we are going to have to go to the “Design” tab that we can see in the upper corner of the window. We will click where it says “Data” and a new menu is displayed, here we will have to choose “Formula”.
After this, a new window will open that will allow us to create our formula . By default we will see a formula in use. In parentheses, you have the current positional argument. In our case, Outlook thinks we want to sum all the cells up.
In case that is the formula we want to use, then we just click it. If we want to use another formula, then read on.
Formulas available in Outlook
In the same way that we enter a formula in Excel, we have to start with an equal sign (=). If you know the formula you want to use, we can just write it after the equals sign in the box.
In parentheses we will have to include the position of the cells of the formula. We can use positions like ABOVE (up), BELOW (down), LEFT (left), or RIGHT (right). We can even use left and right or left and up, for example.
We can also use a particular number format like percent, currency or decimals, we can select this from the drop down list.
Use a function
If necessary, we can use a function from the dropdown list instead of writing a formula. This will also give us more robust options, like ABS for the absolute value and TRUE to evaluate an argument.
If we decide to use a function, it will be filled within the formula box. Then we will finish the formula for the positional argument. When we finish, we will click on “Accept”.
Update formula in Outlook
If after adding a formula we want to update the data in the Outlook table, we can update it manually to include new data. It would not be the same as calculating formulas automatically.
For this we have to select the result of the formula and right-click with the mouse, in the drop-down menu we are going to choose “Update field”.
In this COUNT formula example, we add another row to our table (the one in red) which will obviously increase the count. So we decided to update our formula so that the new data is included.