Start networking and exchanging professional insights

Register now or log in to join your professional community.

Follow

WHAT'S THE DIFFERENCE BETWEEN TH BOTH FUNCTIONS : QUOTIENT & INT ?

user-image
Question added by FITAH MOHAMED , Financial Manager , FUEL AND ENERGY CO for transportion petroleum materials
Date Posted: 2015/04/22
Deleted user
by Deleted user

QUOTIENT, returns the integer of portion of a division.  Use this function when you want to discard the remainder of a division.  =QUOTIENT(5,2) which is5/2, would result "2" and =QUOTIENT(4.5,5.1) returns0.88 on calculator, in excel using this formula would return "1"; negative numbers work same way; =QUOTIENT(-15.5,3.5) which is -15.5 divided by3.5, results "-4".  Calculated it is actually4.43, but our result we need is a whole number   INT, rounds a number down to the nearest integer; =INT(8.9) rounds8.9 down to8;  =INT(-8,9) rounds down to9; as negative numbers are rounded away from zero.  The function could be used with the SUM function in preparing financial statements, to return line item results to rounded down numbers, so function syntax would be =INT(SUM(A1:A13))

 

 

 

Ahmed Maher allam
by Ahmed Maher allam , Senior IT Consultant & System Admin (Lecturer & Trainier) , KGL

I think round, roundup, and rounddown have the same behavior

FITAH MOHAMED
by FITAH MOHAMED , Financial Manager , FUEL AND ENERGY CO for transportion petroleum materials

Both use to extraction the integer number

With a difference

"QUOTIENT" function is used to extract only the integer  result of dividing and it has  specific use

"INT" function is used to extract the integer number and can be used freely in the complex formulas

More Questions Like This