round down

  1. N

    Price list roundup with different parameter

    <colgroup><col><col span="2"></colgroup><tbody> Barcode Price Result 110022002095 43.7535 45 2200000000019 78.75 80 2200000000026 105 105 2200000000033 105 105 2200000000040 105 105 2200000000057 105 105 2200000000064 175.0035 175 2200000000071 52.5 55 2200000000095 15.75 16...
  2. H

    100% round down

    Hi I have an audit matrix document which calculates %age scores for multiple sites. The score should always show a full number (i.e 80%, 90%, etc...), and I am happy for standard rounding to apply (i.e round down for .4 and below, round up for .5 and above) However, I don't want this to apply...
  3. O

    VBA Round a Calculation

    Hello, I've written the below code to leverage Solver. I'd like to RoundDown the answer the code churns out but have been having trouble getting it to work. I've been trying to leverage Application.WorksheetFunction.RoundDown, but can't seem to get it to work. Any help would be greatly...
  4. R

    Round up/down at 1.5

    Hello, I'm looking to create an excel function which will round down anything based on .5 (i.e. 1.5, 2.5.3.5, etc.) and round everything else up. Can you assist as I can't figure out the related function. Thank you in advance!
  5. M

    Need help rounding down results of a formula

    I need help adding round down to an existing formula. Any one out there know how to add? I want to perform the following calculation & round down the results in the same cell. For example. . . my formula in B15 is =D13*F13/1095. Right now the result showing in B15 is 58.35342466. I want the...
  6. A

    Round down .5 in VBA Math.Round function

    This code below looks at field c2 in hours worksheet and writes the text "hours" x amount of times based on the value in that field to the work worksheet. It works great BUT I need it to round DOWN any .5 value instead of rounding up. Is that possible? Can I put like an IF statement that...
  7. T

    Macro to round down cells in a column

    Hi I have looked through various forum threads regarding my problem but I am unable to find anything that solves what I am looking to achieve. I am looking to create a macro that rounds down all the values of column D. So for example even if a value in a cell from column D is 6.98 it would...
  8. H

    =CEILING advanced

    Hello there, I am looking for the opposite of the =CEILING formula. My current formula in cell A2 is =CEILING(A1,0.5) Let's say I have a figure of 0.6 in cell A1, the formula rounds it up to 1.0 in cell A2 But what I want is to round it down to 0.5. In effect I just want it to round down to...
  9. E

    Round to the nearest 10,000

    Hi, can anyone help me round down to the nearest 10,000 So, if it's 84,000, it'll round to 80,000 If It's 86,000, it'll round to 80,000 etc... I found this online, but it doesn't work properly past 100,000..it just rounds down to the nearest 100,000 when it gets past 100,000...
  10. W

    How to lookup data and round down to the lower of the return results if the lookup value falls in betwween the values in the lookup column

    I have a table full of values that I want to look up in a table like below (incomplete data set just for iillustration): <COLGROUP><COL style="WIDTH: 48pt" span=2 width=64><TBODY> Aggregate Industry Equivalent Unit Score Industry Diversity Score 0 0 0.05 0.1 0.15 0.2 0.25 0.3 0.35...
  11. V

    Custom formatting code - rounding problem

    Here the problem raises with rounding the two decimal values. But i need like using trunc in custom formatting. I need the values not to get rounded with decimal but display as it was. Problem 1 [>=1000000]$#0.00,, "M";[>=100000]$#0.00, "K";$#.00 this code converts millions and K with 2...
  12. N

    Advanced rounding question?

    Hi, I've searched some of the other threads, and I find something that is similar to what I need, but not exactly. I hope that one of the volunteers can help, and appreciate the effort in advance. I work in retail and I'm trying to create a formula that will take a dollar amount and round it...
  13. J

    floor and ceiling: round up and down to nearest multiple of 5

    I have created a spreadsheet for a weight training program. In the sheet, I am using a max lift, then basing the workouts off of a percentage of the max lift. I would like the end number to round up or down to the nearest multiple of 5. For example, have 212 round down to 210, have 213 round...

Some videos you may like

This Week's Hot Topics

  • VBA (Userform)
    Hi All, I just would like to know why my code isn't working. Here is my VBA code: [CODE=vba]Private Sub OKButton_Click() Dim i As Integer...
  • List box that changes fill color
    Hello, I have gone through so many pages trying to figure this out. I have a 2020 calendar that depending on the day needs to have a certain...
  • Remove duplicates and retain one. Cross-linked cases
    Hi all I ran out of google keywords to use and still couldn't find a reference how to achieve the results of a single count. It would be great if...
  • VBA Copy and Paste With Duplicates
    Hello All, I'm in need of some input. My VBA skills are sub-par at best. I've assembled this code from basic research and it works but is...
  • Macro
    is it possible for a macro to run if the active cell value is different to the value above it
  • IF DATE and TIME
    I currently use this to check if date has passed but i also need to set a time on it too. Is it possible? [CODE=vba]=IF(B:B>TODAY(),"Not...
Top