rounding

Hello MrExcel Patrons, I have to create a sheet whereby i can enter the values for staff starting times, but they will be exact, for example. 8:23, this figure would need to be rounded to the nearest 15 minute, whether that be up or down. Furthermore i need to calculate from these times the...

Hello, I am trying to calculate numbers using the sum function but sometimes they don't come out whole. I really need them to round UP to the nearest number - how do I do this when using a formula to get the result? E.G - =SUM(D7/2) Thanks in advance!

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 ?

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

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

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

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

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

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

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

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

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

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

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

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

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

Nevermind

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

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

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