Communiquez avec les autres et partagez vos connaissances professionnelles

Inscrivez-vous ou connectez-vous pour rejoindre votre communauté professionnelle.

Suivre

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

user-image
Question ajoutée par FITAH MOHAMED , Financial Manager , FUEL AND ENERGY CO for transportion petroleum materials
Date de publication: 2015/04/22
Utilisateur supprimé
par Utilisateur supprimé

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
par Ahmed Maher allam , Senior IT Consultant , CBK - G&D - AXIS-olutions

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

FITAH MOHAMED
par 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