Results 1 to 6 of 6

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

  1. #1
    Senior Member LalitPandey87's Avatar
    Join Date
    Sep 2011
    Posts
    222
    Rep Power
    14

    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.

  2. #2
    Member
    Join Date
    Jul 2012
    Posts
    55
    Rep Power
    13
    Hi,

    Try =FLOOR(5/2,1)

  3. #3
    Forum Guru Rick Rothstein's Avatar
    Join Date
    Feb 2012
    Posts
    662
    Rep Power
    13
    Quote Originally Posted by LalitPandey87 View Post
    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)?

  4. #4
    Senior Member LalitPandey87's Avatar
    Join Date
    Sep 2011
    Posts
    222
    Rep Power
    14
    Quote Originally Posted by Rick Rothstein View Post
    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.

  5. #5
    Senior Member LalitPandey87's Avatar
    Join Date
    Sep 2011
    Posts
    222
    Rep Power
    14
    Thanks Ingolf

  6. #6
    Forum Guru Rick Rothstein's Avatar
    Join Date
    Feb 2012
    Posts
    662
    Rep Power
    13
    Quote Originally Posted by LalitPandey87 View Post
    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)

Similar Threads

  1. Find the highest then lookup result
    By Stalker in forum Excel Help
    Replies: 4
    Last Post: 04-02-2013, 02:04 PM
  2. Finding highest value in array
    By Rasm in forum Excel Help
    Replies: 15
    Last Post: 06-24-2011, 03:59 AM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •