Get the highest integer quotient of dividend divided by divisor only using formula.

Hi All,

Is there any formula which returns the highest integer quotient if i do division.

For ex.
5/2 will return 2.5 but i need only 2 means the max integer quotient.

i tried =int(5/2) in excel formula and it gives me the exact value but is there any other formula.

Thanks in advance.

Hi,

Try =FLOOR(5/2,1)

Quote:

---

Originally Posted by LalitPandey87

Hi All,

Is there any formula which returns the highest integer quotient if i do division.

For ex.
5/2 will return 2.5 but i need only 2 means the max integer quotient.

i tried =int(5/2) in excel formula and it gives me the exact value but is there any other formula.

---

I am confused as to why you are looking for another formula... do you think there will be a simpler formula than that!!??! Or is that formula not returning the values you actually want (in which case, tell us what those values are)?

Quote:

---

Originally Posted by Rick Rothstein

I am confused as to why you are looking for another formula... do you think there will be a simpler formula than that!!??! Or is that formula not returning the values you actually want (in which case, tell us what those values are)?

---

Thanks Rick for your quick response but i was just asking is there any other formuls to do the same or not.

Thanks Ingolf

Quote:

---

Originally Posted by LalitPandey87

Thanks Rick for your quick response but i was just asking is there any other formuls to do the same or not.

---

Okay, two other possibilities then...

=1*LEFT(F2,FIND(".",A2&"."))

=ROUNDDOWN(A2,0)