# mround

1. ### "MROUND" - Need Min. 0.25 Value

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?
2. ### MROUND with IF Satement

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...
3. ### MRound VBA formula setting all cell values to zero

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...
4. ### If & mround functions

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...
5. ### Calculating Hours with fractions for half hours

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...
6. ### Issue using MROUND function

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...
7. ### Y axis on line chart with non fixed data set (number of decimals differs every time)

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...
8. ### MROUND Problem

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...
9. ### *MROUND, Minimums, and Maximums...oh my

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

### This Week's Hot Topics

• Turn fraction around
Hello I need to turn a fraction around, for example I have 1/3 but I need to present as 3/1
• TIme Clock record reformatting to ???
Hello All, I'd like some help formatting this (Tbl-A)(Loaded via Power Query) [ATTACH type="full" width="511px" alt="PQdata.png"]22252[/ATTACH]...
• TextBox Match
hi, I am having a few issues with my code below, what I need it to do is when they enter a value in textbox8 (QTY) either 1,2 or 3 the 3 textboxes...
• Using Large function based on Multiple Criteria
Hello, I can't seem to get a Large formula to work based on two criteria's. I can easily get a oldest value based one value, but I'm struggling...
• Can you check my code please
Hi, Im going round in circles with a Compil Error End With Without With Here is the code [CODE=rich] Private Sub...
• Combining 2 pivot tables into 1 chart
Hello everyone, My question sounds simple but I do not know the answer. I have 2 pivot tables and 2 charts that go with this. However I want to...