round

  1. R

    combine round and subtotal formula?

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

    Excel not subtracting properly causing "un-rounding"

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

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

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

    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?
  6. A

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

    "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...
  8. V

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

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

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

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

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

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

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

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

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

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

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

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

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

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.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

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

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

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
Back
Top