round

Hi everyone, I'm new and 1st I would like to say thanks for all experts that help us the newbies as me. I am trying to solve a problem, and I would need your help! I'll start run a project of 20 teams. This would be a matrix with 19 rounds played in 10 time slots. And I would like to create a...

Hi, I have a huge dataset and I need to apply conditional formatting in a very strange and complex way. The data is a mix of hard coded and calculated prices. I need a formula that will apply formatting only if the cell ends with an 5 in the second decimal place (20.55, 5.05, 42.95, etc.). I've...

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