rounded

I have a spreadsheet where time is reported in hours.minutes and I need to report in Hour.tenths of an hour to one decimal, rounded up. Not sure what the formula should look like.

Hi everyone!!:) Down below I have a list and the problem is this: I want to generate items from the list when a precise value like: 875 X 1150 or 1478 X 3620 is entered in a cell . Let say, someone has entered : 875 X 1150 or 1478 X 3620 in (column A) and I want in (column B) the rounded...

I want to enter a formula to round the result ex: =c7/a6 ( I want the result of this rounded to 4 digits) =c4*a2+c4 (I want the result of this rounded to 0 digits) I know this is probably simple but I am having a brain fart...:wink: Thanks

Hello, I have reports that are in whole dollars and decimals with subtotals and totals. I need to report these in thousands. The round(x,-3) formula works for presentation for the individual rows and totals, but the sum does not equal the rounded totals and subtotals. I end up having to add...

Hi, This is my first post, hope get this right. I am newish to VBA and have come up against problem (first of many no doubt). I have searched for an answer on the forums and Google but not finding one that works for me. I need to put multiple private subs in one work sheet but am unable to run...

Hello All! I am sure this question has come up numerous times. I have a cell that displays the sum of numbers =P7-P8 I want to round the sum to the nearest 100 Example: $2,550 I want rounded UP to $2,600.00 (the nearest 100) or $9,249 I want rounded DOWN to the $9,200.00 (the nearest...

I have a question about rounding. The exact numbers displaying in the cell in question will vary depending on the value of other cells, but to cite a specific example, I'll use the following numbers. The formula in the cell is returning $322.8703689...., which is correct. It is displaying...

I want 172 to round to 175 187 to 190. Can excel rounding function round like that? If so, what would the formula be? I tried =roundup(cell,-1) for the first example here, but it rounded to 180.

Hi, i was kindly provided a formula as a solution to a problem though, it didn't work 100%. I believe the issue is due to the formula using a rounded number and would like to know of a solution if possible? The formula is =INDEX(J1:AC1,MATCH(D8,INDEX(J2:AC7,MATCH(F4,I2:I7,0),0),-1)) F4 in...

Hi, We have a pricing strategy that we want all rounded to the nearest .95 or .45 if under 500. If over 500 goes to the even dollar. If within 4.00 of a hundred, gets rounded to 99. Examples: 498.00 goes to 499.95 149.00 goes to 148.95 150.25 goes to 150.45 Is there a way to do this, or at...

Hi, I have a spreadsheet that performance data is imported into from two different sources. The main goal is to see when the two data entries do not match. However, the two data sources are never rounded to the same decimal place. For instance performance from 1/31/2017 will be 1.3245687% vs...

I am trying to use a formula within a cell and want the answer rounded up =ROUNDUP((235*25%)+235,0) THIS DOES NOT WORK ANY THOUGHTS

Looking for a way to solve for an issue using an Excel formula. In a table, the values used are often presented as a rounded value. When applied to a sum of a group of numbers, I am looking for a way to set up a flag/alert indicating whether the final value is rounded vs. exact. I figure this...

...thanks for stopping by my question. i hope you're well. I know how to concatenate, but I'm trying to concatenate 3 already-rounded values to a string, but instead my concatenation is including the original decimal places. For example: 7.2 (already properly rounded to 1 decimal place) 3...

Hi, I'm trying to get excel to multiply a figure in a cell by rounded up figure in another cell. I realise that in cell properties it is only displaying the number as a rounded figure rather than change the figure. Is there any way to do that?