I am utilizing "MROUND" to round to values of 0.25, 0.50, 0.75 & 1.00 - it works great, but I can't use a "0.00" value (I need min. 0.25) -- what can I do?
Hello Folks,
I'm trying to use the MROUND function with an IF statement. I need values in Column "A" to be rounded off to the next multiple of 3 if the value is less than or equal to 42. If the value exceceds 42 it needs to be rounded of to the next multiple of 6. The issue I have is that if...
Hi All,
Thanks in advance for any help you can provide.
I have a formula in VBA which rounds the values in a range to the nearest 0.5.
It works fine but it also sets all the cell values to zero if they are blank, does anyone know a way to get past this?
My code is:
For i = 5 To 20...
Hi
Since my last post I have a further query I'm hoping someone might be able to help me with please
The example scenario:
Person 1 has 26 envelopes to open
Person 2 has 15 envelopes to open
Person 1 and Person 2 both work 5 hours per day each
The spreadsheet will capture Target figures...
I have a formula to calculate the number of hours between a start and end time....but cannot get a MROUND function to work, to give me a decimal of half hour.
P27 = Start time
Q27 = End Time
1) This formula gives me good answer if the times are full hours...but rounds down to the nearest...
Hi,
I am new to this forum and have searched through a fair amount of threads without finding a solution. I am using MS Excel 2007 and am having an issue when using MROUND and trying to round to 2.5. Unfortunately I believe it is simply a matter of pointing out an issue in my formula.
An...
Hi there,
I am trying to build a line chart which is based on a data set which will move over the time.
Basically, sometimes my source data will have 4 decimals, sometimes 3, sometimes 2, etc.
For example, on a set of data which will have a minimum of 1.3012 and a maximum of 1.4512, I would...
I'm trying to round up a number to the nearest multiple of another number. I can do this with MRound if i want the multiple to be a fixed amount however i need the multiple to refer to a cell reference.
In this example, multiples are 100 and 50. In row 1 i want 47 to be rounded up to 100 and...
Does anyone know if it's possible to use the mround function subject to certain mins and maxes? Further, is there a way so that the sum of an mround column doesn't exceed a value? See the table below for some details:
So can I:
a) have the formula be constrained to be strictly less than the...
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.