round

Hello, i got a little problem to my rounding function, i got an example Aaron = 120,200 Bella = 120,350 Charlie = 120,670 Dean = 120,880 i wanted to round to Aaron = 120,000 Bella = 120,500 Charlie = 120,500 Dean = 121,000 So far, i got into this mess, working formula, but not intended...

Is there a way to find the maximum and minimum values that round to the same number in a calculation? My work laptop doesn't let me install the XL2BB :( but I will try to explain round(9.35/37.5,2)=0.25 round(9.41/37.5,2)=0.25 If I try to reverse the calculation 0.25*37.5 I get 9.375 (or...

is it possible to combine round and subtotal formula? i can do the subtotal first and then do the round in another cell. this takes 2 cells. is it possible to have this in one formula combined? its a subtotal from a table. edit: solution: Here is How to Easily Combine the ROUND and SUM...

Through my entire process, I round everything with the Round formula since these numbers are designated to be $s to go into an ERP system that should have everything rounded to the 2nd decimal place. The final step in my process is subtracting my post-process rounded side to what it should...

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

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

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?

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

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

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

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

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

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

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

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

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

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

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

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

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