Have you tried formulas for the tables in Microsoft Outlook? Then this is the right page to check how to use formulas for tables in Outlook Online. Formulas are used to perform calculations or specific formatting within the table.
For interactive tables, professional presentations, and many more Microsoft Outlook has a formula feature to use and enhance the table in an effective way.
I have a requirement to use formulas in Outlook Online when I am handling finance things. So here is the experienced method to check out this tutorial.
Formula in the Outlook Online Table
|Formula in Outlook Table||Will sum up the above the cell|
|=SUM(ABOVE)||Will add the above the cell|
|=SUM(BELOW)||Get the Total of both above and below|
|=SUM(ABOVE,BELOW)||Will get the sum of both left and right|
|=SUM(LEFT)||Get Sum results of figures on the Left of the cell|
|=SUM(RIGHT)||Get Sum results of figures on the right of the cell|
|=SUM(LEFT,RIGHT)||Will get a sum of left and above|
|=SUM(LEFT,ABOVE)||Will get a sum of right and above|
|=SUM(RIGHT,ABOVE)||Will get a value of left and below|
|=SUM(LEFT,BELOW)||Will get the value of right and below|
|=SUM(RIGHT,BELOW)||Will get the value of right and below|
Use Formula in Outlook Online
Here are the steps to use a formula in the Outlook Online desktop application.
Step-1: Open Microsoft Outlook in the desktop application.
Step-2: Make sure you have created tables to add formulas for the table in Outlook Online. (Here I have created an investment details table to check for the formulas).
Step-3: Now click the Layout option and click the three ellipses or three dots then click the Formula option.
Step-4: Make sure you have kept the cursor where you want the total amount. Now Formula page will appear and give this formula as =SUM(ABOVE).
Step-5: Now the exact total will be calculated in the column where we required.
Step-6: If you want to get the below cells sum value, then keep the cursor where you want exactly, then type =SUM(BELOW).
Step-7: Here the table column will be added below the value and provide the result.
Step-8: If the user wants to add the right values in the cell, then we can use the formula =SUM(RIGHT).
Step-9: Now the output for the right cell value will be provided in the table in the Outlook Online desktop application.
Step-10: The same thing can apply to the left side value of the cells. We can use this formula as =SUM(LEFT).
Step-11: If you want to add left with right values then use this formula =SUM(LEFT, RIGHT)
Step-12: Now the value will be added to the left and right value and the sum will be calculated in the result column.
These are all the methods to use the formula function in the Outlook Online desktop application.
From this, you have learned how to use the basic formula function in Outlook Online. Using the formula in Outlook is an easy way of calculating the output and thus increases the effectiveness of calculation as well.
- How to Split Tables in Outlook Online
- How to Convert Text to Table or Viceversa in Outlook Online
- Formatting Table in Outlook Online
I am Kirithika and a senior technical content writer expertise in using various Microsoft and Google tools like OneDrive, Outlook Online, Word Online, Microsoft Forms, Microsoft teams, Google Drive, etc. I love to share how-to tutorials, tips, and tricks on these tools. From last 5 years, I am trying to serve various clients across the United States of America. Check out more on About me page.