round

In one of the cells in my worksheet, I have entered the following formula: =CONCATENATE("Qtr 1 Average: $"&SUM(B2+C2+D2)/3)&" ("&SUM(B3+C3+D3)&" gal used)" which gives me the following: Qtr 1 Average: $53.9066666666667 (64.39 gal used) I'd like the number that follows the word "average" to...

I found a way to add "Round()" to a range of cells (https://www.mrexcel.com/forum/excel-questions/618276-add-round-function-all-cells.html). Then I discovered an error in the underlying formulas. I've now decided I need to learn VBA well enough to not have to ask for assistance. But until then...

hi, does anybody knows what is difference between TRUNC and ROUNDDOWN functions in excel? except optional or required for second argument

Hello, I am trying to get C9 to balance out as $347,530.30. Can you help with this please? Please see image attached for details. <colgroup><col width="304" style="width: 228pt; mso-width-source: userset; mso-width-alt: 11117;"> <col width="154" style="width: 116pt; mso-width-source...

Hi, I am a little confused by the following rounding tt = Round(1915.5 * 3.27, 2) 1915.5 * 3.27 = 6263.685 so the rounding should round up 5 to 6263.69 but I am getting 6263.68 What is happening? This is excel 2016 Thanks

I want to round the number for the decimal part 0.6, e.g if the calculated is 4.6 or 7.79 it rounds up, otherwise if the calculated is 2.5 or 9.43 it would round down. Can anyone help me?

Trying to understand a round function. Formula reads like this =round(E3+E7-E42,5) My question is what is the last digit, #5 , doing to the formula? Is it rounding to 5 decibels?

Hi there, I am trying to us a SUMIFS to sum a range of numbers based upon a reference. The reference I am using has 12 decimal places (stored as text), i.e.: 120577342.663008205083 When Excel uses the reference it seems to automatically round it up to 6 decimal places i.e...

Hi there, I am using the Round Function to round some computed percentage values to 0 decimals. The values are: <tbody> 48,4848485 <tbody> 27,2727273 <tbody> 24,2424242 </tbody> </tbody> </tbody> So 100% all together. For the first number the Round Function, i.e...

Hi, I am looking for a way to dynamically change which formula is used depending on the value in another cell, example: <colgroup><col><col></colgroup><tbody> If value is between Use formula 0-40 ROUND 40-100 ROUNDUP 100-1000 ROUND 1000-10000 ROUNDDOWN </tbody> I am looking for a...

When incorpating the round function into my formula, it returns #value !. Without the round formula, I get no error =ROUND(IF((C2-B2)-1>0,TEXT((C2-B2)-1,"#,#0")&UNICHAR(9650),TEXT((C2-B2)-1,"#,#0")&UNICHAR(9660)),0)&"" It would be appreciated if someone could amend my Code

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 guys, I have problems of round up function and would like to ask for help. I have a lot of data needed to be auto round up. 90,91,92,93,94 - all round down to 90 95,96,97,98,99 - all round down to 95 I have tried to search online and tried by myself in excel but couldn't find the solution...

Hi All, In a situation here! Below is a Competition Leaderboard that I am working on for a client. What he wants is for each round, each Player will compete against another based on their position on the leaderboard. For example in the below snapshot Jack played Kevin in Round 2 because they...

Is it possible to extract a value from the listbox? I have a listbox that populates automatically from a table on an excel sheet. It has 7 columns and the number of rows varies in length. I was wondering if I select a row from the listbox is it possible to extrapolate the value that resides...

<tbody> A B C 1 2 TEAM 1 TEAM 1 TEAM 2 3 TEAM 2 TEAM 1 TEAM 3 4 TEAM 3 TEAM 1 TEAM 4 5 TEAM 4 TEAM 2 TEAM 3 6 TEAM 2 TEAM 4 7 TEAM 3 TEAM 4 8 </tbody> Hy all, i have in column A, (starting in A2) the above: I now need all the combinations of games ( just 1 round)...

Hello This is my data file <tbody> Stone # Ref Document No Customer Ref No. Product # Shape Name Report # Seal No Size Pcs Weight Color Clarity L01354 2217 L01354 Round 1243777 1243777 +1.00-1.49 1 1.02 K VS2 L01355 2217 L01355 Round 1243965 1243965 +0.50-0.69 1 0.50 J VS2...

Hey everyone, I'm looking to round a selected range of cells but the code seems to be taking a really long time to run. I'm hoping someone can help me improve what I've written: Selection.SpecialCells(xlCellTypeVisible).Select For Each cell In Selection cell.Value =...

Hi please have a look at the screen short of the following chart. What I need is to make labels in round figures so that it may not show up messy and overlapping each other. Any suggestion would be appreciated. Thanks EDIT : Rounding the cell ( column) does not have any effect on...

So I have a Large Date - Small Date which outputs the amount of days in-between. What I need is to convert this number into a number of months and round that up. For example, and output of 49 Days should equal 2 months. 15 Days should equal 1 month. So on and so forth, all the way to 48 months...