• About
  • Contact
  • Privacy Policy
  • Submit For Review
  • Template Gallery
  • Excel 2016 Udemy Course
  • Skip to primary navigation
  • Skip to main content
  • Skip to primary sidebar

TheAppTimes

App Reviews, Tutorials, & Gadget News Hub

  • Gadgets
  • How To
  • Mobile Apps
  • Software and Web Apps
  • Buying Guides
  • Show Search
Hide Search
Home » How To » Excel Formulas for Beginners : How to Create, Copy, and Edit Simple Formulas

Excel Formulas for Beginners : How to Create, Copy, and Edit Simple Formulas

April 15, 2016

One of the most powerful features in Excel is the ability to do numerical calculations using formulas. Excel acts just like a calculator, allowing you to easily add, subtract, multiply, and divide numbers. In this post, we’ll show you how to create simple Excel formulas in Excel using cell references.

Mathematical Operators

The standard mathematical operators in Excel are the Plus sign for addition (+),  Minus sign for subtraction (–), Asterisk for multiplication (*), Forward slash for division (/), and a Caret (^) for exponents. All the formulas in Excel always begin with the equals sign (=).

Using Cell References

Cell references refer to the location of a cell in the worksheet. It consists of the column letter followed by the row number that intersects its location such as A1, F2 or C3. Cell references are used in a number of Excel activities such as creating formulas, in functions, in charting and so on.

The advantage of using cell references in formulas is that if the data located in the referenced cells changes, the formula is automatically updated to reflect the change, thereby avoiding the cumbersome task of rewriting the formula every time something changes. This also means that your formulas are always accurate.

Using cell references

 

You usually combine a mathematical operator with cell references to create different types of simple formulas in Excel. Excel formuals can include a combination of cell references and numbers as well. Here are a few examples.

= N1+P2 : This formula uses cell references to add the values in cells N1 and P2.

=A1-345 : This Excel formula involves a combination of a cell reference and a number. Excel subtracts 345 from the value contained in cell A1.

=B2/B1 : This Excel formula divides cell B2 by the value contained in cell B1.

=C22*3.65 : This Excel formula multiplies the value in cell C22 by 3.65.

How to Create a Simple Formula in Excel

Let us use some values to calculate the total sales value in the first quarter. In the image displayed below, we have the sales data for the months Jan to Mar 2016. Let’s find the total sales value earned in the first quarter.

1. Select the cell that will contain the formula. In our example, we’ll select cell B5.

Select cell B5

2. Type the equals sign (=) in cell B5. It will appear in both the cell and the formula bar.

3. Type the cell reference in the formula: cell B2 in our example. A blue border will appear around the referenced cell.

Entering the formula

4. Type the mathematical operator you want to use. In our example, we’ll type the addition sign (+).

5. Next, type the cell reference you want to add next, in our example, it it cell B3. A red border will appear around the referenced cell.

continuing the formula

6. Type the addition sign (+) again.

7. Next, type the cell reference you want to add next, in our example, it it cell B4. A purple border will appear around the referenced cell.

8. Press Enter on your keyboard. The formula will be calculated, and the net value will be displayed in cell B5.

Creating simple excel formulas

If the result of a formula is too long, it will display as pound signs (#######) instead of a value. This means that the column is not wide enough to display the contents of the cell. Increase the column width to see the full value.

Modifying Cell References

As I mentioned earlier, cell references allow you to update data in your worksheet without having to rewrite formulas. In the previous example, if we modify the value of cell B2 from $3657 to $3857. The formula in B5 will automatically recalculate and display the new value.

ALSO READ:  Extract URLs From Hyperlinked Text Using Macros in Excel 2010

Modifying cell references

Creating Excel Formulas Using Point-and-Click Method

You don’t have to manually enter cell references in Excel to create the formulas. A simple point and click action on the cells will suffice. This method will save a lot of time and effort when creating formulas. In our previous example, instead of typing the cell references such as B2, B3, and B4, simply select the respective cells to include them in the formula.

So what you will essentially be doing is:

1. Type =

2. Click cell B2.

3. Type the addition sign (+)

4. Click cell B3.

5. Type the addition sign (+)

6. Click cell B4.

7. Press Enter.

Copying Formulas

Formulas can also be copied to other cells using the fill handle. This can save a lot of time and effort if you need to perform the same calculation multiple times. When you copy a formula, Excel automatically adjusts the cell references where the formulas are copied to. Let’s take the previous example and add some expenses for the 3 quarters. Let’s now say you want to find the total expenses incurred in the first quarter. You don’t have to create a new formula for it. Instead simply drag the fill handle to the new cell to get the total expenses.

1. Click cell B5.

2. Place the mouse pointer at the bottom corner of the cell until it turns into a thin plus sign.

3. Click and drag the corner to the next cell, cell C5.

Copying formulas

The formula is now pasted into the new cell with the cell references automatically adjusted to reflect the values in c2, c3, and C4.

Editing Excel Formulas

Sometimes you may want to modify an existing formula. In the previous example if you have entered =B2+B3-B4 instead of =B2+B3+B4, you can correct the mistake in the formula quite easily.

1. Select the cell containing the formula you want to edit. In our example, we’ll select cell B5.

2. Click the formula bar to edit the formula. You can also double-click the cell to edit the formula directly within the cell. A border will appear around the referenced cells.

Editing Excel formulas

3. In our example, we’ll change the last part of the formula to display + instead of –

4. Press Enter to complete the correction.

The formula will be updated, and the new value will be displayed in the cell.

View all Excel Formulas in a Spreadsheet

If you want to see all of the Excel formulas in a spreadsheet, you can hold the Ctrl key and press the ` (grave accent key). The grave accent key is usually located in the top-left corner of the keyboard. Press Ctrl+` again to switch back to the normal view.

If you found this tutorial helpful, be sure to check out more good stuff in our Learn Excel series. If you want to learn Excel from scratch, consider taking up our Udemy course, Excel 2016 for Beginners. It is available at a nominal price of just $10.

Tweet70
Share21
WhatsApp
Pin905
Buffer
996 Shares
Tweet70
Share21
WhatsApp
Pin905
Buffer
996 Shares

Filed Under: How To Tagged With: excel how to, learn excel

You May Also Like

Ways to Use Excel Mobile - TATFI
10 Creative Ways to Use Excel Mobile in your Business
How to Get Rid of the Paste Options Menu in Word, Excel and PPT
How to Get Rid of the Paste Options Menu in Word, Excel and PPT
How to Calculate Number of Days Between Two Dates in Excel
How to Calculate Number of Days Between Two Dates in Excel

About Adeline Gear

Adeline is a tech enthusiast who loves exploring the latest tools and applications in the marketplace. She also loves her Android and spends time reviewing apps and playing games when she has the time.

Reader Interactions

Leave a Reply Cancel reply

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

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Primary Sidebar

Hottest New Gadgets!

Amazfit Falcon Smartwatch - TATFI

The Amazfit Falcon is a Military Grade Smartwatch with Premium Looks and Great Features

Couchmaster Cyboss Ergonomic Couch Desk - TATFI

Couchmaster Cyboss is an Ergonomic Desk to Keep Off Neck Pain

Philips Hue Festavia String Lights - TATFI

Add a Bit of Sparkle to Your Christmas Tree with Philips Hue Festavia String Lights

Samsung Galaxy Tab A7 Lite Kids Edition - TATFI

This Kid Friendly Tablet from AT&T is a Thoughtful Gift for Your Little One This Christmas

Is An iPhone Really Worth It - TATFI

Is an iPhone is Really Worth It?

Devices You Might Want to Try - TATFI

4 Fantastic Devices You Might Want to Try

Amazon Kindle 2022 - TATFI

Meet the Amazon Kindle 2022 – Packed with New Features

Popular Tags

android android apps android games android how to apple casino games chrome extensions excel excel how to facebook gadgets gaming gmail google instagram ios apps ios games ios how to ios tips ipad iphone kids apps learn excel management microsoft music apps new releases outlook how to photo apps powerpoint powerpoint how to productivity Samsung security smartphone smartphones software tablet tablets twitter web browsers windows 10 word how to xbox youtube

Disclosure

TheAppTimes is a participant in the Amazon Services LLC Associates Program, an affiliate advertising program designed to provide a means for us to earn fees by linking to Amazon.com and affiliated sites.
Tips to Boost Your Ranking and Sales on Etsy - TATFI

5 Ways to Boost Your Ranking and Sales on Etsy

PunchBee Time Management App - TATFI

Know How You Spend Your Time with PunchBee

DevOps Model Explained - TATFI

The Complete Guide to DevOps: How the Model Works and Who It Benefits

Approaches to Digital Marketing - TATFI

Blending Technical and Content-Centric Approaches to Digital Marketing

Tech Tips For Startups - TATFI

Useful Tech Tips For Startups

Boox Tab X Android eReader - TATFI

Boox Tab X is an Android eReader That Helps You Do More Than Just Read

Best e Readers to Buy in 2023 - TATFI

5 Best eReaders to Buy in 2023

Best Translation Apps for Android - TATFI

5 Great Translation Apps for Android

Dynamic Island Feature on Your Android - TATFI

How to Get the Dynamic Island Feature on Android

Connected TV Advertising In 2023 - TATFI

5 Things You Need To Know About Connected TV Advertising In 2023

Smart Cost Cutting Strategies for SMEs - TATFI

5 Smart Cost Cutting Strategies for SMEs

Technologies behind the online casino world - TATFI

The Latest Technologies Behind the Online Casino World

TheAppTimes © 2023 // Runs on StudioPress