rounding

  1. U

    numbers to currency without rounding

    So cell B-2 is an amount in currency. Cell B-3 is 3% of that amount. When that calculation is completed, the result may be carried three or four decimal places. When the result of that calculation shows up in B-3, it rounds up to the nearest penny. How do I stop that from occurring ?
  2. J

    rounding question

    I want to round to the quarter hour based on 7/8 minute split. I found two formulas. Is one better than the other? Any known issues using one versus the other? They both seem to work ok. ActiveCell.FormulaR1C1 = "=ROUND(RC[-1]*96,0)/96" ActiveCell.FormulaR1C1 = "=TIME(HOUR(RC[-1])...
  3. C

    Rounding Formula

    I have inherited an Excel Spreadsheet (Excel 2002) at work which contains the following formula (it contains 381 characters). The calculations are mostly to do with money. Some of the answers I get are correct. Some are a penny out and others are several pence out. I have managed to work out...
  4. J

    Rounding To Nearest $0.95

    Hello all, I don't know if this is even possible, but I have a cell that returns a certain value and sometimes it's very random. I need the cell to round to the nearest $0.95, but don't know if it's possible to do that. For example, a cell may return $39.64, but is there a way to force it to...
  5. starl

    Floating Decimal Issue? - Rounded values not matching

    I have two cells I compare (via VBA). Both cells are in pivot tables. Both values appear to match, down to the decimal of .295. I've used a simple = formula and Excel says they match. I used format cells to extend the decimal as far as it can and I do not see any extra numbers. Via VBA, I Round...
  6. J

    Rounding and applying remainders.

    Hello again! I want to make an automatic table that looks basically like this.... <tbody> Beginning total 143.9847 Full 143 Tenths 9 Hundredths and Below 8.4 </tbody> Hopefully whatever is entered into the "Begging Total" would automatically be broken into the "Full"...
  7. L

    Need to change rounding so $192.50 is $192, not $193. And, $192.00 would need to stay $192.

    Hi all, I'm working on a spreadsheet of income figures for a particular program (like, a public support program, not a computer program). In this program, we've got certain rules about rounding numbers. To keep it short, I need a way to make a $192.50 into $192, not $193. And I need $192.00 to...
  8. B

    Round Months

    Hi All, To track employees' service time I have 2 dates (A1=start date and B1=end date). After substracting B1-A1/365.25 the outcome could e.g. be 10 years 5 months, but could also be 10 years and 7 months (cell is formatted on number). What I'd like to do is, have a formula round down months...
  9. R

    CONCATENATE Help

    :confused: I am attempting to use a CONCATENATE formula to conver Bytes to KB but I am having trouble. I hope someone can help me. Here is my example: A1 B1 D1 File.txt 6,356,388 6207.41015625 KB I want it to return as 6,208 KB Here is my formula: =CONCATENATE((B1/1024)," ","KB") Anyone...
  10. D

    Round Entire Worksheet

    Is it possible in Excel 2007 to round an entire worksheet at once? I want to round figures to the nearest 1,000 then drop the last 3 zeros. See data below. I want to take the data shown in the 1st picture and make it look like the 2nd. I know I can do it cell by cell but can it be done to...
  11. S

    VBA Rounding Problem

    Hi,<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p> <o:p></o:p> I have a problem with the way results of a calculation are displayed on a user form I’ve made in VBA for Excel 2003.<o:p></o:p> <o:p></o:p> I have two calculations which work out two results –...
  12. ClimoC

    Try this: Round Doubles with custom floor and ceiling to rounding

    Anyone come across this before? Essentially, trying to round like this: 04:01:00 to 04:00:00 04:02:00 to 04:00:00 04:03:00 to 04:00:00 04:04:00 to 04:05:00 04:06:00 to 04:05:00 04:07:00 to 04:05:00 04:08:00 to 04:05:00 04:09:00 to 04:10:00 etc so kind of like normal rounding to 5...
  13. D

    erratic decimal points and rounding

    Hi all, First post here! I have a minor issue which causes major headaches... Excel 2010.... Excel looses decimal places when I copy information from cells. Cell B1: 0.00 Cell B2 2.00 Cell C1: " =B1 &"(" &B2&")" Cell C1 now reads 0(2) - I want it to give the full decimal places -...
  14. S

    Fantasy football calculators

    Newbie here, I apologize if this has been covered and/or is a stupid question: I'm trying to set up a sheet that will allow me to enter statistics from NFL games and generate the fantasy points earned by each player. This is not hard on the surface, but the problem is calculating the points...
  15. B

    Round to nearest whole number and paste resulting value

    Nevermind
  16. E

    Excel 2007 Rounding Issues

    I work with currency in Excel and I need a way for Excel to round to the nearest hundredth without excluding decimal places. What I mean is, when you take the equation $123.50*0.8717 the answer is $107.65495. When you use the formula ROUND($123.50*0.8717,2) the answer is $107.65. However, it...
  17. A

    Rounding milliseconds

    Hi, I'm using time with millisecond precision. I have some values such as hh:mm:02.345 (2 seconds, 345 milliseconds). Using second() function in excel seems to round this up/down to the nearest second depending on if millisecond part is greater/less than 0.5. I would like to always round down...
  18. J

    Rounding

    how to automaticly round a cell to the nearest 100 upon input. Is there a macro code for this??
  19. T

    Vba help!

    I'm currently trying to create a rounding code in VBA. How do I create a rounding code that allows all values in one column in the excel spreadsheet to be rounded to a specific number of places?
  20. M

    how to change rounding rules?

    The formula of round currently rounds up if the decimal value is 0.5 and above and rounds down if the decimal value is below 0.5. Is there a way to change this? I want a round up if the decimal value is 0.8 and above and round down if the decimal value is 0.7 and below. E.g. If value is 2.7...

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