Results 1 to 6 of 6
  1. #1
    3 Star Lounger
    Join Date
    Apr 2001
    Posts
    304
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Ignoring the remainder in a formula (Excel 2000)

    I have a formula: =A4/333*750 where the value in cell A4 is equal to 700. If you divide 700 by 333, you get 2.102, but I would like it to ignore the decimal points for the rest of the equation and just multiply 2 by 750. And I would like it to always round down (so the remainder is, in essence, always ignored) If the value in cell A4 is 900, instead of rounding 2.702 up to 3 and multiplying by 750, I'd like it to round down to 2. Can anyone help?

    Thanks - Sat.

  2. #2
    Platinum Lounger
    Join Date
    Jan 2001
    Posts
    3,788
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Ignoring the remainder in a formula (Excel 2000)

    Use the INT function

    =INT(A4/333)*750

  3. #3
    3 Star Lounger
    Join Date
    Apr 2001
    Posts
    304
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Ignoring the remainder in a formula (Excel 200

    You guys rock! Thanks!

  4. #4
    Uranium Lounger
    Join Date
    Dec 2000
    Location
    Salt Lake City, Utah, USA
    Posts
    9,508
    Thanks
    0
    Thanked 6 Times in 6 Posts

    Re: Ignoring the remainder in a formula (Excel 200

    FYI there's also the =ROUNDDOWN(value,place) function, which is helpful when you want to round down to the nearest decimal.
    -John ... I float in liquid gardens
    UTC -7DS

  5. #5
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Ignoring the remainder in a formula (Excel 200

    The right paren in your formula is in the wrong place to do what was asked. The formula should be:

    <pre>=INT(A4/333)*750
    </pre>

    Legare Coleman

  6. #6
    Platinum Lounger
    Join Date
    Nov 2001
    Location
    Vienna, Wien, Austria
    Posts
    5,009
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Ignoring the remainder in a formula (Excel 200

    =INT(A4/333)*750

    HTH
    Gre

Posting Permissions

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