ابدأ بالتواصل مع الأشخاص وتبادل معارفك المهنية

أنشئ حسابًا أو سجّل الدخول للانضمام إلى مجتمعك المهني.

متابعة

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

user-image
تم إضافة السؤال من قبل FITAH MOHAMED , Financial Manager , FUEL AND ENERGY CO for transportion petroleum materials
تاريخ النشر: 2015/04/22
مستخدم محذوف‎
من قبل مستخدم محذوف‎

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
من قبل Ahmed Maher allam , Senior IT Consultant & System Admin (Lecturer & Trainier) , KGL

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

FITAH MOHAMED
من قبل 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

المزيد من الأسئلة المماثلة