mround

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