# rounddown formula

1. ### need help with multiple formulas in one cell

Theres a couple things i want to do in one cell. I have three cells. The first two cells B6 and B7 have two values In the third cell B9 I have an existing formula =ROUNDDOWN(MIN(B6,B7),0) It works great, it inputs the lower value of the two. Now, heres my problem. In the same cell B9 I...
2. ### If odd then even...

Hi: I think that I am going about this wrong. I have the length of a needed part (balance rod) in cell L127=rounddown((L108-2),0). We have switched vendors and now are only using even length balance rods. L108 contains the product height divided by 2. L127 (balance length) can never be less...
3. ### Rounddown

How can I ROUNDDOWN a number to nearest 50, so for example my numbers are 82.3 or 96.7 I want to round down to 50 in each case, or if the numbers are 336.6, 244, 298.2, I want 300, 200 and 250 respectively. 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.

### Which adblocker are you using?

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

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