rounding

  1. C

    Conditional formatting using formula to always round up a number

    I have a column of Currency values, but I want the values to always round up to the next whole number. I don't want to have to enter a formula for each cell, since it is meant to be a quick entry. Example of what is entered into a cell What I would like to see visible 10.10 $11 10.21 $11...
  2. D

    Rounding in Excel

    Hi all, I am looking for a way to automate this into a formula or something.. now I have this covered with a lot of formulas within conditional formatting but am looking for a better solution to put it in one spreadsheet so everybody can use just one file. After measuring we get a lot of...
  3. J

    Round into a Total Number

    I have these figures below, that I need to round up to the next or last $50 dollars. The problem is I need the total of all the ROUNDED figures to equal $100,000. Any help is appreciated. $10,204 $5,102 $4,082 $1,020 $12,755 $2,041 $9,694 $9,184 $3,571 Total = $100,000
  4. BPW

    Rounding Range to Specific Number

    I'm attempting to break out a quantity for six locations by a percentage, retaining pack rules with the sum equating to the original quantity. I'm spinning my wheels on a solution and haven't been able to find any help searching around. Is this possible? Would anyone be able to provide...
  5. P

    Rounding decimals to the nearest quarter

    I am working on a staff schedule budget. I am trying to calculate based on budget and rate how may hours an employee can work. Here is the catch, while an employee may get a budget of $2889.00 at a rate of $15.00/hr which would give them 192.6 hours. However, since our timesheet system only...
  6. E

    Rounding only if the 3rd decimal place is greater than 5

    Hi everyone, I have a task where I need to round a number up to 2 decimals ONLY IF the third decimal place is greater than 5, otherwise it'd stay as it is. For example, if the figure is $26.24701 then round it to $26.25 If it's $26.24301 then keep the 5 decimals. I've been trying to run an...
  7. A

    specific round figure

    I have a question and I hope to get an answer from you. I have grades for some students and I want to make a round figure for the marks in a special way as follows: If the figure in B1 contains 0.1 the round figure should be same 0.1 If the figure in B1 contains 0.2 the round figure should be...
  8. L

    SUM IF - Round up If - Round Down Else

    Hi all, I need help building out a formula here. If I have a column of data that I am performing a SUMIF on, I would like to incorporate a Rounding calculation to the SUMIF formula. If the sum of the data's decimal point is below .5, round down nearest whole number, if over .5 round up to...
  9. M

    Rounding the months and days in between 2 dates

    I'm calculating number of months and days in between 2 dates (jan1 2019 & Dec 31, 2019) using a formula Value(Datedif(A1,B1,"M")&"."&datedif(a1,b1,"md")+1) and i am getting a result of 11.31 but i wanted to appear as 12 instead (since 31 completes the whole month). I want to get the real...
  10. T

    Rounding currency up at 6 instead of 5

    Hello - I know this sounds strange, but I am looking for a way to condition data in spreadsheet cells to round down at 5 and round up at 6. Example: $2.245 would be $2.24 AND $2.246 would be $2.25. Is this even possible as it seems all of rounding functions in Excel and based on traditional...
  11. S

    Rounding while still seeing ".0"

    Good Morning, I'm trying to use a simple rounding formula but I don't want to lose the ".0" when a number, say 14.96, is rounded up to 15. I cannot format the cell itself. Ideas on how to do this. It's probably super simple but I've been brain farting all afternoon/evening....
  12. T

    Rounding in CONCATENATE

    Hello, I can´t solve the issue with CONCATENATE and rounding in this function like this screen: https://ctrlv.cz/oEeL. I need to round it only to 2 numbers after the decimal point (examlpe: 7.13%, not 7.15615615686164489%) Can anyone help me with this function to solve it? PS: Function is...
  13. J

    Asymmetric Rounding "Rounding-Half-Down"

    While I have been able to code a function for Asymmetric Rounding "Rounding-Half-Up" (code attached). But, I am struggling with Asymmetric Rounding "Rounding-Half-Down" method. Public Function RoundHalfUpAsym( _ ByVal myNum As Double, _ ByVal myFac As Double) As Double...
  14. R

    Rounding dates to the next specific date

    I am working on a spreadsheet for monitoring personnel records, especially in relation to the disposal of the records. I current have the spreadsheet which calculates 6 years after an employee left, and which will compare this to today's date to flag they have been gone for 6 years. Our policy...
  15. M

    Roundup within an IF statement after a condition is met.

    Hi Everyone, I'm new to this group and not well trained with Excel, I've spent my morning looking at formulas trying to find the solution. Here is the formula I have written, which works. I need to show a value of 7 if Z2 is less than 0.5, but I need it to roundup Z2 to the next whole number...
  16. S

    Rounding oddity

    The weirdest thing is happening ... In my table, I'm running a quick if/then calc to confirm if the sum of the values in one column equals the sum of values in another column. For some reason I keep getting a negative answer. It turns out there appears to be a rounding issue, as you can see...
  17. JTL9161

    Rounding

    I am doing a sum formula and need some help on rounding. One of my examples: 77.8 (shows as 78) minus 82.5 = -4.7 How do I get it to show a total of 4.5? Because in reality 78 - 82.5 = -4.5 Another one: 109.1 (shows as 109) minus 95.5 = 13.6 but I really need it to say 13.5 Any help...
  18. S

    Rounding a date to the nearest half year

    Hi, I'm looking to create a formula that will round a date to the nearest half year (either the start of the year or the middle of the year depending upon which is next) i.e if the date was 01/08/2019 the formula would round to 01/01/2020 if the date was 03/04/3021 the formula would round to...
  19. I

    Rounding using ceiling with conditions

    I'm trying to round to the nearest quarter hour but if the rounding is less than 1:15 I want the cell to just display 1:15 I've tried =IF(CEILING((B2-A2),"00:15")<"01:15","1:15",CEILING((B2-A2),"00:15")) and it just puts 1:15 is every cell no matter if it's above or below 1:15 Below is an...
  20. R

    Division Formula & ROUNDING UP

    Im running a league and I have x amount of players paying $13.50 a week. I am trying to get a formula set-up for this that ROUNDSUP Example for week #1 the total money collected was $1,374 If I divide that =C9/13.5 by $13.50 it comes up with 101.7777778 Now what I am trying to come up with...

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
Back
Top