Learn Excel Now

Conquer the Fear of Excel

  • Home
    • Our Team
  • Training
    • Custom Training
      • Custom Virtual Group Training
      • Custom Onsite Group Training
      • Consulting Services
    • Excel
    • MS Office
    • Outlook
    • PowerPoint
    • Word
    • OneDrive
    • Google
  • All-Access
  • eLearning
    • Excel Foundations
    • Micro Courses
      • Simply Excel
      • Simply Excel Pt. II
  • Resources
    • Contact
    • FAQ
    • New User Onboarding
  • Login

Creating Basic Formulas Part 3: Division

February 8, 2023 by Madeleine Moucheron

Excel formulas can simplify the essential mathematical operations of addition, subtraction, multiplication, and division.

In Part 2 of this series, we covered creating basic multiplication formulas in Excel. To finish this series, we’ll tackle how to divide with the program.

Division Formula

Division has the same capabilities as addition and multiplication. To divide cells, you can either type in the totals or the cell names and use the “/” sign to indicate division. If you want to divide C7 and C5, which will be 6 and 2 for this example, you can write the formula as C7/C5 or 6/2.

You can also use the QUOTIENT function, which works the same way the =SUM and =PRODUCT functions do. In the cell where you want your total to appear, type “=quotient” and choose the =QUOTIENT function. Select the cells you want to divide and hit enter.

There are an extensive number of Excel formulas that enable more advanced mathematical functions, but these four are the most essential formulas to learn for Excel beginners.

We at Learn Excel Now hope you feel comfortable creating addition formulas with Excel. Next week, we’ll wrap up this series with how to divide in Excel so stay tuned!

Like Learn Excel Now? Follow us on social media and share our content with your networks!

All Access Subscription
Our 1-year all-access subscription provides step-by-step guidance for mastering Microsoft Office applications, with workshops, exercises and quick reference eGuides. It's perfect for anyone that needs to brush up on certain skills or even folks who need to learn the programs - from a beginner’s level.
Excel Foundations
Take the fear out of Excel with this 20 module self-paced training course. You will cover the most essential topics to develop a solid foundation of Excel or a lifetime of mastery.

Learn Excel Now helps you conquer the fear of Excel. By providing self-paced and instructor-led training and free strategies and guides, we leave no Excel mystery unsolved.

  • Home
  • Training
  • All-Access
  • Excel Foundations
  • Resources

Connect with Us

  • Facebook
  • Linkedin

Contact

Learn Excel Now
questions@learnexcelnow.com
1-484-259-7664 or 1-800-964-6033
660 American Ave
Suite 203
King of Prussia, PA 19406

Microsoft® Office Excel® is a registered trademark of the Microsoft Corporation in the United States and other countries. All rights reserved.

Copyright © 2023 ­Learn Excel Now

Terms of Service

Privacy Policy

Copyright © 2023 · News Pro Theme on Genesis Framework · WordPress · Log in

WELCOME BACK!

Enter your username and password below to log in

Forget Your Username or Password?

Reset Password

Lost your password? Please enter your username or email address. You will receive a link to create a new password via email.

Log In