divide for whole number

  1. K

    Help with formula for rounding up/down & divisible by 3

    Hi, I think it's my maths skills (limited!) that are holding me up on solving this one... I am trying to write a formula to help me round up/down to the nearest whole number that is divisible by 3. My original numbers are already rounded up/down to 2 decimal points. I am using Excel 2010...
  2. S

    Formula to divide proportionally?

    I have a range of 6 cells that I am dividing days between based on their %. My problem is if there are only 3 of those 6 cells not blank they are all 3, 33%. It can not add up to more than the total which is 100. Likewise if only 2 cells and obviously each are 50% and I need 50% of 25 one...
  3. R

    VB for Whole Number result after divide

    Hi... I need to divide a value in an integer and receive the result as a whole number... not with the fraction. If a divide 7 by 2, I need the result in my int to be 3 not 3.5. I tried using Rnd but got all fraction as a result. Thanks.

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top