# Thread: Ignoring the remainder in a formula (Excel 2000)

1. ## 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. ## Re: Ignoring the remainder in a formula (Excel 2000)

Use the INT function

=INT(A4/333)*750

3. ## Re: Ignoring the remainder in a formula (Excel 200

You guys rock! Thanks!

4. ## 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.

5. ## 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>

6. ## Re: Ignoring the remainder in a formula (Excel 200

=INT(A4/333)*750

HTH

#### Posting Permissions

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