# round

1. ### Using ROUNDUP and IF within a cell, with a calculation already in it.

Hi all, Hoping this one is a testing problem for the maestros on here. I have a G8, which contains the following formula =VLOOKUP(\$C\$2,Variables!G24:H43,2,FALSE)*\$G\$4 This returns a result of 0.4. What I want to is within the same formula in G8, add something that checks that if the value is...
2. ### Find a lower value from dynamic range

I'm trying to replace a dropdown menu, whith a cell. The user is going to input the real distance in this cell. As it's works now, the user select the nearest "visible" distant (there can be several selectables but the one whith the best / longest option is visible) So this works like this...
3. ### VBA round() function and worksheetFunction.Round() returning different results

Does anyone know why the following happens? In vba... MsgBox Round(0.25, 1) 'shows 0.2 MsgBox worksheetFunction.Round(0.25, 1) 'shows 0.3 wtf is happening here?
4. ### Two identical columns in pivot with different data

Thanks in advance for any ideas you may have on my issue here: I have column ("times,") formatted as time (XX:XX:XX AM/PM) that has times in it. I have a second column ("times round,") that is referring to the first one and is ROUNDING (down) those times to 30 minutes (and formatted the same)...
5. ### "1/1/00," shows in list of Times in Pivot Table, but not in the original referenced column.

Greetings All - Thank you for giving my problem a look: I have column ("times,") formatted as time (XX:XX:XX AM/PM) that has times in it. I have a second column ("times round,") that is referring to the first one and is ROUNDING (down) those times to 30 minutes (and formatted the same). I have...
6. ### VBA How to round a value that is copied or a range that is being pasted ?

Good day, Looking for a way to round a value I am trying to copy or the range I am trying to paste. The code is below. Tried inserting Round., but do not seem to find the correct placement. Also tried numberFormat = "0.0". Could round the whole column after pasting in the values, but would...
7. ### Modify array and include 3 conditions in formula

Good day, Some time ago, I was helped through this forum with creating a formula for my boss' product prices but now he wants it to be modified. The current formula is this...
8. ### Round last integer to the nearest value from a list

Hi, my boss wants me to create a formula for the prices of his products. He wanted all prices below 99.99 to be rounded up to xx.97 and the values from 99.99 and greater to be rounded up to xx.00 and I have managed to put together a round formula like this...
9. ### Rounding time up to the nearest quarter hour

I am tracking time for short projects and having trouble with rounding to the nearest quarter hour. I am not sure why, but sometimes projects that are exactly 15 minutes round up to the next quarter hour and sometimes it remains at 15. I would like projects of 15 minutes or less to bill at 15...
10. ### round average

Hello to all! I really need your help... I'm currently following an online course about Supply chain planning and here is the issue i'm having, i can't round the average number! I'm doing the exact same things as the teacher is showing and all i get as a result is error. First thing i do is...
11. ### Maintain last 0 if value is ".5", without using simple Round.

Good morning all, I have some variables dimmed as doubles, and I'm wondering the easiest way to check if the value ends in .5, for it to show as .50. I can't simply round because I need it show the values out to 3, or 4 decimals if the value is say, 0.375. Is there an easy check for this...
12. ### VBA Insert SUM formula not result of SUM

Hi Folks, I have invoice data separated with blank lines between invoice numbers and I'm currently using the following code which gives me the result of summing up the line items of a given invoice and it works fine. But what I would like to do is actually insert the sum formula for the rows...
13. ### RANK gives different rank for same value

Hi guys, I'm getting totally crazy over the RANK-function. In this sheet, B2 = RANK(A2,\$A\$2:\$A\$3) and B3 = RANK(A3,\$A\$2:\$A\$3), and as you can see, it gives me two different ranks for the same value. These are constants (not formulas) and prove that the value is the same, formula in C2 =...
14. ### SUM IF - Round up If - Round Down Else

Hi all, I need help building out a formula here. If I have a column of data that I am performing a SUMIF on, I would like to incorporate a Rounding calculation to the SUMIF formula. If the sum of the data's decimal point is below .5, round down nearest whole number, if over .5 round up to...
15. ### Round up time by quarter of the hour in VBA

Hello The macro below works well for converting military time to regular time and adjusts the one difference in timezone. I would like to round up the outputted time by quarter of the hour as I am currently doing it manually after running the macro using the MROUND function. Ex 05:20=05:30 &...
16. ### Rounding with exponent

Hi everyone, this is my first post here. I consider myself an intermediate skill-level with Excel, and I use it at work quite a bit, but right now I'm stumped. In the simplest form, I'm trying to figure out a formula that will multiply a cell by a another cell which is a percentage, then round...
17. ### Excel Round Function

Hello, I have an inquiry regarding round function and not sure if there is a solution or not The numbers in Column "A" are depends on some calculations What I need is to round the numbers in Column "A" to be only as the numbers in Column "D" (looks like (250, 250*2, 250*3, 250*4...)) I used...
18. ### Screwing up a nested IF function

Hi. I'm creating a spreadsheet for a music group that pays tutor expenses for travel. For a round trip up to 200 miles the standard payment is £25, for a round trip of between 200 and 400 miles its £50, and anything over a 400 mile round trip pays £100. What I want is to be able to enter the...
19. ### Excel Round off formula to get desired result

Which uniform excel round off formula should I use to get the following result by multiplying certain figures by 2.57?: 6600*2.57 = 17000 7680*2.57 = 19700 11040*2.57 = 28900 12750*2.57 = 33400
20. ### Rounding in CONCATENATE

Hello, I can´t solve the issue with CONCATENATE and rounding in this function like this screen: https://ctrlv.cz/oEeL. I need to round it only to 2 numbers after the decimal point (examlpe: 7.13%, not 7.15615615686164489%) Can anyone help me with this function to solve it? PS: Function is... ### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?    1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option. Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com". Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button. Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button. Go back