SayPro Use Formulas in a Table

It is possible to use formulas and some basic functions in tables in Microsoft Word. It is not as powerful at calculating as Excel, and the table does not have the row and column headers like a spreadsheet, however table cells can still be referenced by using a cell reference such as B1.

  1. Click in the cell where you want to insert the formula
  2. Click on the Layout tab of the Ribbon
  3. Click the Formulas button
  1. Enter the formula in the Formula box

The image above shows the Sum function being used to add the values in a column

  1. Select the required format from the Number format drop down list such as currency or whole number
  2. The Paste function drop down list can be used to insert basic functions into the formula
  3. Click OK

If any of the values being used in a formula changes, the formula will need to be manually updated. Formulas use fields which can be updated by selecting the field and pressing theF9 key.When inserting functions the direction of the cells can be used as an alternative to the cell references in Word. For example, =SUM (ABOVE) is used instead of =SUM (B2:B5) in the formula shown above. This is because the formula adds all the values in the cells above.

Tsakani Stella Rikhotso | Monitoring & Evaluation OfficerSayProWebsite: www.saypro.onlineCell: 27 (0) 713 221 522Email: tsakaniStudy and Qualifications www.saypro.onlineOur Company www.saypro.online

SayPro is a group of brands leading in Africa’s development, building innovative online solutions and a strategic institution on child growth, youth empowerment and adult support programmes, applications in Africa.SayPro Core Skills and Expertise:

  • SayPro Artificial Intelligence, Graphics, Online Design and Web Development
  • SayPro Higher Education, Certification, eLearning Development, Qualification Design and Online Training.
  • SayPro Community Development in Youth Unemployment, HIV/AIDS, Human Rights and Gender-Based Violence
  • SayPro Company Registrations, Tax, VAT and Website Designs.
  • SayPro Research, Opportunity Sharing in Tenders, Funding and Contact Directories.
  • SayPro Monitoring, Evaluation, Knowledge Management, Learning and Sharing.

SayPro is providing international and global opportunities for African youth. Partner with SayPro now by sending an email to info or give us a call at + 27 11 071 1903Please visit our website at www.saypro.online Email: info@saypro.online Email: info@saypro.online Call: + 27 11 071 1903 WhatsApp: + 27 84 313 7407. Comment below for any questions and feedback. For SayPro Courses, SayPro Jobs, SayPro Community Development, SayPro Products, SayPro Services, SayPro Consulting, and SayPro Advisory visit our website to www.saypro.online