Returns the integer part of the quotient. This function can be used to round off the decimal part of the quotient.
SyntaxQUOTIENT(numerator,denominator) Numerator dividend. Denominator Divisor.
DescriptionIf any argument is non-numeric, function QUOTIENT returns the #VALUE! error value.
When we want to divide A by B in EXCEL, we only need to enter "=A/B" in the cell.
But when we want to keep only the integer part of the calculation result and remove the decimal part, we need to use the QUOTIENT function.
It should be noted that the result of this function directly discards the decimal part, not rounding.
Next, I will show you the specific steps to use this function, taking this table as an example.
■ Select cell C2, find and select the QUOTIENT function in the search box, and click OK.
Select A2 and fill in the "dividend"
Fill in "divisor" in B2
Click OK to get the operation result that only retains the integer part.
Position the cursor to the lower right corner of cell C2, and pull down to fill the cell when it is in the shape of +, and the calculation results can be obtained in batches.
Articles are uploaded by users and are for non-commercial browsing only. Posted by: Lomu, please indicate the source: https://www.daogebangong.com/en/articles/detail/san-jiao-han-shu-zhong-de-chu-fa-yun-suan-ji-qiao-QUOTIENT-han-shu-de-ying-yong.html
评论列表(196条)
测试