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

Some videos you may like

This Week's Hot Topics

  • Turn fraction around
    • Started by PabloFer
    • Replies: 32
    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 ???
    • Started by Sleeplol
    • Replies: 24
    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
    • Started by johnsonk
    • Replies: 22
    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
    • Started by Dellboy
    • Replies: 25
    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
    • Started by ipbr21054
    • Replies: 22
    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
    • Started by Ramballah
    • Replies: 22
    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...
Top