Hi Everyone,
Seeking some help please, can't seem to work this out (however I am not amazing yet at excel to be honest).
I have this formula:
=DAYS360($B$1,IF(I5="",F5,I5),FALSE)/90
I want to round down the result to whole number;
Example: If result is 31.7, it's round down to 31.
Is there...
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...
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...
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 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.