mround

  1. J

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

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

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

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

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

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

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

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

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

Watch MrExcel Video

Learn Excel - Changing Case in Excel: Lower, Upper, Proper: Podcast #1356

This Week's Hot Topics

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.
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.
Go back
Top