round function

Hi, I'm very new to Excel and need some help (with a maybe very basic function). I need to create a system that choose between two parameters to round up or down the number depending on a condition. This is for scoring students with a decimal system, so I need to round the final score. What I...

13.13 25.33 26.32 75.12 81.21 #VALUE! how to use the round function to get the round figure in the result. pls help. A113.13225.33326.32475.12581.216#VALUE!A6A6=ROUND(A1:A5,0)

<colgroup><col><col span="2"></colgroup><tbody> Barcode Price Result 110022002095 43.7535 45 2200000000019 78.75 80 2200000000026 105 105 2200000000033 105 105 2200000000040 105 105 2200000000057 105 105 2200000000064 175.0035 175 2200000000071 52.5 55 2200000000095 15.75 16...

HI i currently have the beow code which can add an round formula to an Exiting formula in a cell Sub add_round() Dim rng As Range For Each rng In Selection rng.Value = "=Round(" & Mid(rng.Formula, 2, 9999) & ",2)" Next rng End Sub however i need to undo this -...

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 have a cell which contains the formula =(E10/D10)*100. This cell returns a number 79.23457. How do I round this to the nearest whole number? Changing the format to number and 0 decimal places won't work as I need to apply a CountIfs to this cell an the result is incorrect (technically...

I have data set of times. I want to round the each time to nearest 10th minute. A sample of data set & expected answer is shown below. Thanks you very much for your time. <tbody> 8:11 8:10 7:57 8:00 8:03 8:00 4:33 4:30 5:08 5:10 </tbody>

I have multiple pages that require a check. I have manually checked, and verified the tabs do total correctly. This an example of the existing syntax: =IF(A27=Blue A27+Green A27+Purple A27,0,"check"). I need it round to a specific decimal, because it is returning "check" and it should be zero...

Hi, I have thought out an example that may help clarify what I am looking for. Say I wished to purhcase 200 bananas for 25 retail outlets. I can only ship whole bananas. Is there a function that will split the bananas out to each store in a whole number to a max of 200 for all stores...

Dear I have a Number 18684 and I want this to be rounded to 18690. How to apply round up function..

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

Hi, I was using the "round" functionin VBA and realized that it does not work, because it uses the "Bankers" method of rounding, whereas I want the "Arithmatic" rounding, I looked through the web and went to: http://support.microsoft.com/kb/196652 But the problem is the function is not...

I'm using Excel 2007...does anyone know why the the sum of values for one column in my pivot table would differ from the total sum of my linked table? I am using the Round(Rand()*100,0) function to determine the values for each cell in this one column. I notice that these values change each...

Hi Mr Excel gurus: Can't seem to come up with quite the right syntax here. I need to round the results of this formula to the nearest whole number: =$D6-($D6*E6), yielding the resulting rounded number in the same cell. Any help is appreciated! Thanks