TeachUcomp, Inc.

 MY CART
  • VIDEO COURSES
    • All-Access Subscriptions
    • Business Licensing
    • Course List
      • Accounting
      • Adobe
        • Acrobat
        • Lightroom Classic
        • Photoshop
        • Photoshop Elements
      • Crystal Reports
      • Employment Skills
        • Interview Skills
        • Resume Skills
      • For Lawyers
        • Excel for Lawyers
        • Outlook for Lawyers
        • QuickBooks for Lawyers
        • Word for Lawyers
      • HTML
      • JavaScript
      • Microsoft Office
        • Access
        • Excel
        • Microsoft Office Suite
        • OneNote
        • Outlook
        • Outlook on the Web
        • PowerPoint
        • Publisher
        • Word
      • Microsoft Project
      • Microsoft Teams
      • QuickBooks Online
      • QuickBooks Pro
      • Sage
        • Peachtree
        • Sage 50
      • SQL
      • Windows
    • Video Course Options
  • SUBSCRIPTIONS
  • MANUALS
    • Adobe
      • Acrobat
      • Lightroom Classic
      • Photoshop
      • Photoshop Elements
    • Crystal Reports
    • For Lawyers
      • Excel for Lawyers
      • Outlook for Lawyers
      • QuickBooks for Lawyers
      • Word for Lawyers
    • HTML
    • JavaScript
    • Microsoft Office
      • Access
      • Excel
      • OneNote
      • Outlook
      • Outlook on the Web
      • PowerPoint
      • Publisher
      • Word
    • Microsoft Project
    • Microsoft Teams
    • QuickBooks Online
    • QuickBooks Pro
    • Sage
      • Peachtree
      • Sage 50
    • SQL
    • Windows
  • REFERENCE CARDS
    • Adobe
      • Acrobat
      • Lightroom Classic
      • Photoshop
      • Photoshop Elements 2023
      • Photoshop Elements 2022
      • Photoshop Elements 2021
      • Photoshop Elements 2020
      • Photoshop Elements 2019
      • Photoshop Elements 2018
      • Photoshop Elements 15
    • Google
      • Google Classroom for Teachers
      • Google Docs
      • Google Drive
      • Google Forms
      • Google Sheets
      • Google Slides
    • Mac OS
      • Mac OS Ventura-Mojave Keyboard Shortcuts
    • Microsoft Office
      • Excel Formulas and Functions
      • Excel Keyboard Shortcuts
      • Microsoft Office 365
        • Access for Office 365
        • Excel for Office 365
        • Microsoft Office 365
        • Outlook for Office 365
        • PowerPoint for Office 365
        • Publisher for Office 365
        • Word for Office 365
      • Microsoft Office 2021
        • Access 2021
        • Excel 2021
        • Microsoft Office 2021
        • Outlook 2021
        • PowerPoint 2021
        • Publisher 2021
        • Word 2021
      • Microsoft Office 2019
        • Access 2019
        • Excel 2019
        • Microsoft Office 2019
        • Outlook 2019
        • PowerPoint 2019
        • Publisher 2019
        • Word 2019
      • Microsoft Office 2016
        • Access 2016
        • Excel 2016
        • Microsoft Office 2016
        • OneNote 2016
        • Outlook 2016
        • PowerPoint 2016
        • Publisher 2016
        • Word 2016
      • Microsoft Office 2013
        • Excel 2013
        • Microsoft Office 2013
        • OneNote 2013
        • Outlook 2013
        • PowerPoint 2013
        • Word 2013
      • Microsoft Office for iPad
        • Microsoft Office for iPad
    • Microsoft Teams
      • Microsoft Teams
    • QuickBooks Online
      • QuickBooks Online
    • QuickBooks Pro
      • QuickBooks Pro 2023
      • QuickBooks Pro 2022
      • QuickBooks Pro 2021
      • QuickBooks Pro 2020
      • QuickBooks Pro 2019
      • QuickBooks Pro 2018
      • QuickBooks Pro 2017
      • QuickBooks Pro 2016
      • QuickBooks Pro 2015
      • QuickBooks Pro 2014
    • Sage
      • Sage 50 Accounting
    • SQL
      • SQL
    • Windows
      • Windows 11
      • Windows 11 and 10 Keyboard Shortcuts
      • Windows 10
  • STICKERS
    • Chrome OS
      • Chrome OS for Chromebooks
    • Mac OS
      • Mac OS Ventura
      • Mac OS Monterey-Mojave
    • Microsoft Office
      • Word and Excel (Mac) 2022
      • Word and Excel (PC/Windows) 2021-2016 and 365
    • QuickBooks Desktop
      • QuickBooks Desktop (PC/Windows) 2023
      • QuickBooks Desktop (PC/Windows) 2022-2015
    • Windows
      • Windows 11 and 10
  • SUPPORT
    • Company
      • About Us
      • Blog
      • Contact Us
      • Our History
      • Our Philosophy
        • Customer Service
        • Mission
      • Policies
      • Testimonials
    • Contact Us
    • FAQ
    • Help
    • Lost Password
    • Register a Product
  • LOGIN
    • Manage My Account
    • Member Login
    • My Courses
Shop Now

Creating Formulas in Microsoft Excel 2010

by Keeley Byrnes / Thursday, November 21 2013 / Published in Excel 2010, Latest

Writing Formulas

You use formulas to perform mathematical functions on cells. There are two basic ways of writing formulas available: “ranged syntax” or “simple syntax.” A “syntax” is simply a way of expressing or writing something. It is important to note that these two syntaxes are not mutually exclusive! In fact, your more complex formulas will often incorporate elements of both in order to arrive at the desired result. Typically, you will use the simple syntax to perform multiple mathematical calculations on multiple cells. You use the ranged syntax to perform a single mathematical function over multiple cells.

To write a formula, first click into the cell where you want the results of the formula to appear. Next, write your formula. When you are finished, exit the cell to display the answer to the formula that you wrote. Once again, this is the concept of “content versus display” at wok. The actual content of the cell will be the formula, but the cell will display the answer to the formula. If you click into the formula cell after it has been created, you will see the actual formula displayed in the Formula Bar and the answer displayed in the worksheet. To show the actual formulas in the worksheet, you can press the “Ctrl” key and the ` (single left quotation mark) key. Each time your do this, Excel will toggle the worksheet display between the answers and the formula.

When creating ranged syntax formulas, first select the cell into which you wish to enter the formula. Start by typing the equal sign. Formulas always start with an equal sign (=). This prevents Excel from interpreting the formula as a simple text entry- since formulas are just letter/number combinations. Next, type the name of the function which you wish to perform on the cell range or cell ranges. Then type an open parenthesis. Next, input the cell range or cell ranges upon which you wish to perform the function. Finally, type a closed parenthesis. Then exit the cell using your keyboard, or click the green checkmark button in the Formula Bar, to set the formula. Note that you don’t use spaces between elements in the formula. However, they are not case sensitive.

Creating a simple formula is like writing a standard math problem. Once again, you start by selecting the cell where you want to enter the formula. Type an equal sign (=). Next, type the cell addresses that you want to use in the formula joined together with the standard mathematical operators. You can also enter standard numbers into a formula, if desired. However, you will more often want to manipulate the values of the cells (which may change) and thus you will more commonly use cell references, instead. If you want to perform a single calculation on a range of cells, it is usually easier to create a ranged formula instead of a simple formula. In simple formulas, the standard order of operations applies: designated operations are performed from left to right with anything in parenthesis calculated first, then exponentiation, then multiplication and division, and finally addition and subtraction.

Note that you can also use both syntaxes within a single formula. For example, if you wanted to sum the first ten cells in column A and then subtract from that value the sum of the first ten cells in column B, you could express it as a single combined formula such as: =SUM(A1:A10)-SUM(B1:B10). In this case, you are using a simple syntax formula to subtract the values derived from two ranged syntax formulas. Most of the more complex formulas that you create will incorporate both syntaxes in order to derive the answer.

Formulas that use cell references will automatically be recalculated when you enter or change the values in the cells referenced by the formula. This is one of the best features of Excel, and one of the reasons that you will rarely find numbers entered into a formula.

When you use cell addresses in formulas you can either type them, or use the mouse to select the cell or cell ranges that you want to insert. As always, once you are finished writing the formula, leave the cell in order to save the formula and display the answer.

 

Check out these two videos on Ranged Formula Syntax and Simple Formula Syntax:

 

 

 

 

 

 

 

Tagged under: 2010, 2013, creating, excel, forumlas. autosum, help, how-to, microsoft, training, tutorial

About Keeley Byrnes

Keeley is our Director of Marketing and has been with TeachUcomp since 2010. Keeley manages all aspects of our Marketing Department, acts as liaison for our reseller and affiliate partners and also authors courses in software and taxation.

What you can read next

Class Tracking in QuickBooks for Law Firms- Instructions: A picture of a user editing the “Class List” in QuickBooks Desktop Pro.
Class Tracking in QuickBooks for Law Firms- Instructions
A picture of the interface in the Excel training named
Excel Training Tutorial Free Online
Save a Document in Word 2013- Tutorial: A picture of the
Save a Document in Word 2013- Tutorial
Save $150! One Year Online Entire Library $49. Click here for more info.

 

Recent Posts

  • Add Space in HTML – Instructions

    Add Space in HTML: Overview             This tu...
  • The Optics Panel in Camera Raw in Photoshop – Instructions

    Overview:             The Optics panel in Camer...
  • The Color Grading Panel in Camera Raw in Photoshop – Instructions

    Overview:             The Color Grading panel i...

Categories

Archives

  • GET SOCIAL

© 2001-2023 Copyright TeachUcomp, Inc. All rights reserved.

TOP
Sale! 20% OFF Store-wide 0 Days 19 Hours 38 Minutes 12 Seconds      Use Coupon: AH20
Shop Now