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

[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.

Thanks in advance.

[Ingolf]

Hi,

Try =FLOOR(5/2,1)

[Rick Rothstein]

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)?

[LalitPandey87]

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.

[LalitPandey87]

Thanks Ingolf

[Rick Rothstein]

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)