Tips and Tricks
34 Views Microsoft Outlook logo on a blue background Not every table we create or every calculation we come up with needs to be done in Excel. If you use Microsoft Outlook and want to include a table with a formula in your email, it̵ 7;s easier than you think. There are many uses for formulas in tables in your Outlook emails. You might send final grades to a student, total sales to an employee, or some emails you received from a customer. Whatever it is that requires you to fill a table in Outlook, here’s how to add a formula or function for your numbers.

Insert a table in Outlook

If you have already set up your data table in your email, you can skip to the next section to add the formula. But if you haven’t inserted a table yet, you can do it in a few clicks. In the email window, go to the Insert tab and click the Table drop-down list. Drag through the squares to set the number of columns and rows you want to use, then click to insert the table. On the Insert tab, click Table and choose a format You can also select “Insert Table” from that dropdown and then enter the number of rows and columns, in addition to configuring the way the table fits. Click “OK” to insert the table. On the Insert tab, click Table, Insert Table and enter a size

Add a formula to a table cell

Once you have your table and its contents in your email and are ready to add the formula, click in the cell where you want the formula. Click in a table cell You will see the Layout tab appear at the top of the window. Go to Layout and click on ‘Data’. Choose “Formula” from the drop-down menu. On the Format tab, click Data, Formula Now you will see the formula window open to create your formula. By default, you may see a commonly used formula set up for you. In parentheses you have the positional argument that is recognized. In our case, Outlook believes that we want to SUM all the above cells. Formula for sum above If this is the formula you want to use, you can click “OK” and insert it so easily. If you want to use a different formula or paste a function from the list, read on.

Formula

Just like how you enter a formula in Excel, it must start with an equal sign. If you know the formula you want to use, such as MIN, MAX, or AVERAGE, simply type it after the equals sign in the Formula box. In parentheses, specify the position of the cells for the formula. You can use positions such as UP, DOWN, LEFT or RIGHT. You can also use LEFT, RIGHT for cells to the left and right, LEFT, ABOVE for cells to the left of and above the cell, and RIGHT, DOWN for cells to the right and below the cell. Formula for Sum Left, Right

Number format

If you want to use a particular number format, such as percentage, currency, or decimals, select it from the drop-down list. Select a number format RELATED: Enter zero for a number in Excel

Paste function

If you prefer, you can use a function from the drop-down list instead of typing a formula. This also gives you more robust options, such as ABS for absolute value and TRUE for evaluating an argument. If you choose to use a function, it will be filled in for you in the Formula box. Then finish the formula with your positional argument. Paste a function When you’re done, click “OK” and you should see the result of your formula in the selected cell.

Example average formula

In our email we send our student their final grade average. So we enter AVERAGE (ABOVE) and click “OK”. You can then see the final average for the cells above the formula. Average formula and result in Outlook

Example counting formula

For this next example, we’ll count the number of emails we’ve received from a customer. So we enter COUNT (UNDER) and click “OK”. And we have our result. Count formula and result

Update the formula in Outlook

If you add a formula and then change the data in the table in Outlook, you need to manually update the formula to include the new data. This is in contrast to Excel, which automatically recalculates formulas for you. Select the formula result, right click and choose “Update Field” from the menu. Right click and choose Update Field In our example of the COUNT formula, we added another row to our table (in red), increasing the number. So we updated our formula to include the new data. Result of updated field The next time you need to structure a bit of data in your Outlook email, remember that you can put a formula into a table in no time! Not all tables we create or calculations we calculate need to be done in Excel. If you’re using Microsoft Outlook and want to include a table with a formula in your email, it’s easier than you might think. There are many uses for formulas in tables in your Outlook emails. You can send the final grades to a student, the total sales to an employee, or the number of emails received from a customer. Whatever you need to fill a table in Outlook, here is how to add formula or function for your numbers.

  • Insert table in Outlook
  • Add a formula to a table cell
    • Formulas
    • Number Format
    • Paste function
    • Example of an average formula
    • Example of counting formula
  • Update formula in Outlook

Insert table in Outlook

If you have already configured your data table in your email, you can skip to the next section to add the formula. But if you haven’t inserted a table yet, you can do so with a few clicks. In the email window, go to the Insert tab and click the Table drop-down list. Drag the squares to set the number of columns and rows you want to use, then click to insert the table. On the Insert tab, click Table and choose a size You can also select “Insert Table” from this drop-down list, then enter the number of rows and columns in addition to configuring how the table fits. Click “OK” to insert the table. On the Insert tab, click Table, Insert Table and enter a size

Add a formula to a table cell

Once you have your table and its contents in your email and are ready to add the formula, click inside the cell where you want the formula to go. Click inside a table cell You will see the Layout tab appear at the top of the window. Go to Layout and click on «Data». From the drop-down menu, choose “Formula”. On the Layout tab, click Data, Formula Now you will see the Formula window open to create your formula. By default, you can see a commonly used formula configured for you. In parentheses, you have the positional argument that is recognized. In our case, Outlook thinks we want to sum all the cells ABOVE. Formula for the above sum If this is the formula you want to use, you can click «OK» and insert it easily. If you want to use a different formula or paste a function from the list, read on.

Formulas

Just like the way you enter a formula in Excel, it must start with an equal sign. If you know the formula you want to use, such as MIN, MAX, or AVERAGE, you can just type it after the equal sign in the Formula box. In parentheses, indicate the position of the cells of the formula. You can use positions like ABOVE, BELOW, LEFT or RIGHT. You can also use ones such as LEFT, RIGHT for cells to the left and right, LEFT, ABOVE for cells to the left and above the cell, and RIGHT, BELOW for cells to the right and above. below the cell. Formula for the sum Left, Right

Number Format

If you want to use a particular number format, such as a percentage, currency, or decimal places, select it from the drop-down list. Select a number format

Paste function

If you prefer, you can use a drop-down function instead of typing a formula. It also gives you more robust options, like ABS for absolute value and TRUE for evaluating an argument. If you choose to use a function, it will be populated for you in the Formula box. Then end the formula with your positional argument. Paste a function When you are done, click «OK» and you should see the result of your formula in the selected cell.

Example of an average formula

In our e-mail, we send our student his final average. So, we enter AVERAGE (ABOVE) and click «OK». You can then see the final average for the cells above the formula. Average formula and result in Outlook

Example of counting formula

For this next example, we’re counting the number of emails we received from a customer. So, we enter COUNT (BELOW) and click «OK». And we have our result. Counting formula and result

Update formula in Outlook

If you add a formula and then edit the data in the table in Outlook, you will need to manually update the formula to include the new data. This is different from Excel, which automatically recalculates formulas for you. Select the result of the formula, right click and choose «Update Field» from the menu. Right click and choose Update Field In our example COUNT formula, we added another row to our array (in red), which increases the count. So we’ve updated our formula to include the new data. Result of updated field The next time you need to structure a bit of data in your Outlook email, remember that you can include a formula in an array in no time! Microsoft Outlook logo on a blue background Not every table we create or calculation we figure needs to be done in Excel. If you’re using Microsoft Outlook and want to include a table with a formula in your email, it’s easier to do than you might think. There are plenty of uses for formulas in tables in your Outlook emails. You might be sending final grades to a student, total sales to an employee, or a count of emails received from a customer. Whatever it is that you have to fill a table for in Outlook, here’s how to add a formula or function for your numbers.

Insert a Table in Outlook

If you already have your table of data set up in your email, you can move onto the next section to add the formula. But if you haven’t inserted a table yet, you can do so in a couple of clicks. In the email window, head to the Insert tab and click the Table drop-down box. Drag through the squares to set the number of columns and rows that you want to use, and then click to insert the table. Alternatively, you can select “Insert Table” in that drop-down list, and then enter the number of rows and columns in addition to configuring the way that the table fits. Click “OK” to insert the table.

Add a Formula to a Table Cell

Once you have your table and its contents in your email and are ready to add the formula, click inside the cell where you want the formula to go. You’ll see the Layout tab appear at the top of the window. Go to Layout and click “Data.” In the drop-down menu, pick “Formula.” Now, you’ll see the Formula window pop open to create your formula. By default, you might see a commonly used formula set up for you. In parentheses, you have the positional argument that’s recognized. In our case, Outlook believes that we want to SUM all the cells ABOVE. Formula for Sum Above If this is the formula that you want to use, then you can click “OK” and insert it that easily. If you want to use a different formula or paste a function from the list, read on.

Formula

Just like how you enter a formula in Excel, it should start with an equal sign. If you know the formula that you want to use, such as MIN, MAX, or AVERAGE, you can simply type it after the equal sign in the Formula box. In parentheses, include the position of the cells for the formula. You can use positions like ABOVE, BELOW, LEFT, or RIGHT. You can also use those such as LEFT, RIGHT for cells on the left and right, LEFT, ABOVE for cells to the left of and above the cell, and RIGHT, BELOW for cells to the right of and below the cell. Formula for Sum Left, Right

Number Format

If you want to use a particular number format, such as percent, currency, or decimals, select that in the drop-down list. Select a number format RELATED: How to Enter Zero Before a Number in Excel

Paste Function

If you prefer, you can use a function in the drop-down list in place of typing a formula. This also gives you more robust options, like ABS for absolute value and TRUE for evaluating an argument. If you choose to use a function, this will populate inside the Formula box for you. Then, finish off the formula with your positional argument. Paste a function When you finish, click “OK,” and you should see the result of your formula in your selected cell.

Example Average Formula

In our email, we are sending our student their final grade average. So, we enter AVERAGE(ABOVE) and click “OK.” You can then see the final average for the cells above the formula. Average formula and result in Outlook

Example Count Formula

For this next example, we are counting the number of emails that we received from a customer. So, we enter COUNT(BELOW) and click “OK.” And we have our result. Count formula and result

Update the Formula in Outlook

If you add a formula and then change the data in the table in Outlook, you’ll need to manually update the formula to include the new data. This is unlike Excel, which automatically recalculates formulas for you. Select the formula result, right-click, and choose “Update Field” from the menu. In our COUNT formula example, we added another row to our table (in red), which increases the count. So, we updated our formula to include the new data. Result of updated field The next time you need to structure a bit of data in your Outlook email, remember that you can include a formula in a table in no time! READ NEXT

  • › AMD’s New RX 7000 GPUs Are Really Good and Really Cheap
  • › Astronomers Discover Closest Black Hole to Earth (Which is Still Far)
  • › How to Remove Followers on Instagram
  • › How to Sign Out of Google on All Your Devices
  • › Get Ready to See Popup Tips on Your Windows 11 Taskbar
  • › How to Use Microsoft Excel Templates for Event Planning


Leave a comment

Your email address will not be published. Required fields are marked *