ExcelCSE.com

Menu
  • Excel 101
  • Excel Functions
  • Excel Formula
  • Contact Us
How to Use Excel > Excel Functions > Excel QUOTIENT Function

Excel QUOTIENT Function

How to Use the Excel QUOTIENT Function
Table of contents :

  • What is the Excel QUOTIENT Function?
  • QUOTIENT Syntax
  • How to Use QUOTIENT Function in Excel
  • QUOTIENT Example

Excel Quotient Function

What is the Excel QUOTIENT Function?

The QUOTIENT function returns an integer portion of the division. This function is useful if you don’t need the remainder of a division.

QUOTIENT Syntax

QUOTIENT(numerator, denominator)

numerator, required, the number to be divided (the dividend)

denominator, required, the number that will divide the numerator (the divisor)

Usage Note:

  • Returns #VALUE! error if non-numeric fills the numerator or denominator argument
  • Returns #DIV/0! error if zero fills the denominator argument
  • Use the MOD function to find the remainder of a division
  • Use the division operator “/” for the division with a remainder

How to Use QUOTIENT Function in Excel

For example, there is data like the image below. What are the results of the QUOTIENT function in column B?

How to Use Quotient Function in Excel

QUOTIENT Function #1

=QUOTIENT(A2,B2)

The result is #DIV/0! Error, because the denominator is zero.

QUOTIENT Function #2

=QUOTIENT(A3,B3)

The result is 2. The excel QUOTIENT function results are integer numbers, but you can enter decimal numbers in the numerator or denominator arguments.

QUOTIENT Function #3

=QUOTIENT(A4,B4)

The result is 1. Like the previous example, you can use the decimal number in both QUOTIENT function arguments. For QUOTIENT function #3 the decimal number fills the numerator argument.

QUOTIENT Function #4

=QUOTIENT(A5,B5)

The result is 2. Decimal numbers fill both the numerator and denominator arguments, but the result remains integer number.

QUOTIENT Function #5

=QUOTIENT(A6,B6)

The “number” 5,5 seems like a number but is a text; decimal number separators should use a period but use commas. Excel thinks it’s not a number, but a text.

The result is a #VALUE! Error.

QUOTIENT Function #6

=QUOTIENT(A7,B7)

The result is 3.

Please see the image below for the results of the six functions above.

Quotient Example

QUOTIENT Example

Another article using or explain about QUOTIENT Function
  • How to Separate Date and Time in Excel

Another Math Function

Another article about Math Function
  • Excel SUBTOTAL Function
  • Excel AGGREGATE Function
  • Excel PRODUCT Function
  • Excel CONVERT Function
  • Excel SUMIFS Function
  • Excel SUMIF Function
  • Excel SUM Function
  • Excel SUMPRODUCT Function
  • Excel QUOTIENT Function
  • Excel MOD Function
Usefull links
  • Microsoft QUOTIENT function documentation
Share
Tweet
Google+
Email
Prev Article
Next Article

Related Articles

Excel MATCH Function
What is the Excel MATCH Function? Excel MATCH function returns …

Excel MATCH Function

Excel AVERAGE Function
What is the Excel AVERAGE Function? The Excel AVERAGE function …

Excel AVERAGE Function

Excel INT Function
What is the Excel INT Function? The excel INT function …

Excel INT Function

Excel SUMIF Function
What is the Excel SUMIF Function SUMIF is a function …

Excel SUMIF Function

Excel TIME Function
What is the Excel TIME Function? The Excel TIME function …

Excel TIME Function

Tags:Division Remainder and Quotient Excel Quotient Function Find the Quotient and Remainder How is the Quotient Calculated How To Do Quotient How To Find the Quotient Math Function Quotient and Remainder Quotient Example Quotient of a Number Quotient of integers Quotient Remainder Formula the Quotient of a Number What Does Quotient Mean What Does Quotient Mean in Math What is a Quotient What is the Quotient of a Number Whats a Quotient

Categories

  • Excel 101
  • Excel Formula
  • Excel Functions

Recent Posts

  • How to Combine and Separate First and Last Name in Excel
  • How to Merge Cells in Excel without Losing Data
  • How to Merge Cells in Excel
  • Excel WEEKDAY Function
  • Excel CHOOSE Function
  • Excel VALUE Function
  • Excel NUMBERVALUE Function
  • Excel TEXT Function
  • Excel TRIM Function
  • VLOOKUP Multiple Criteria – Solution for Numeric or Non-Numeric Result
  • VLOOKUP MATCH – a Combination for a Solution
  • IFERROR VLOOKUP – Solution for VLOOKUP NA Error
  • VLOOKUP Error – Frequently Error and Solution
  • VLOOKUP REF Error – Causes and Solutions
  • VLOOKUP NA Error – Causes and Solutions
  • INDEX MATCH – Excel VLOOKUP Alternative
  • Excel VLOOKUP Function
  • Excel MATCH Function
  • Excel INDEX Function
  • Excel IFNA Function

ExcelCSE.com

The Ultimate Guide How to Use Excel Better
Copyright © 2019 ExcelCSE.com
Contact Us - Privacy Policy - Sitemap | Theme by MyThemeShop.com

Ad Blocker Detected

Our website is made possible by displaying online advertisements to our visitors. Please consider supporting us by disabling your ad blocker.

Refresh