rounding

  1. W

    rounding error

    Hi, i'm facing an issue with rounding error and i would like to know if there is a way to solve it. below is an simple example. <colgroup><col style="text-align: center;"><col style="text-align: center;"><col style="text-align: center;"><col span="3" style="text-align...
  2. B

    Round up issue

    HI All, I know it might sounds silly but Im looking to round up or down below formula. I was trying multiple ways and still excel not rounding up this :( IF(K10="Order",((SUM($J5:$U5))/(COUNT($J5:$U5)-COUNTIF($J5:$U5,0)))*X8,0) result in this example was 935 Thank you for any ideas
  3. H

    100% rounding

    Hi I have an audit template where we have a set of scored criteria. each one marked green = 5 points amber = 3 points red = 0 points We add up all the the score, using aggregate(9,6,range) We then calculate a %age grade using a simple divide total by max possible total formula This works...
  4. B

    Rounding off decimals

    How to round off 19 years 2 months to 19 years, 19 years 3 months 20 days to 19 years 3 months, 19 years 6 months 6 days to 19 years 6 moths and 19 years 9 days 20 days to 20 years in excel?
  5. S

    VBA- Rounding a static value to closest increment of a Loop/Array created from another static value

    <tbody> INCREMENT STATIC 1 STATIC 2 VALUE .25 100 100.35 .45 200 201.55 .65 300 302.75 </tbody> I'm struggling to figure out in VBA the most efficient way to create a loop/array within the value in the STATIC 1 column using the increment in same row, and then rounding the STATIC 2...
  6. L

    Rounding up or down depending on...

    When it comes to rounding I use excel like everyone else. I’ve recently come across an engineering specification that rounds up or down to an even decimal place if the second decimal ends in a 5. i.e 2.45 to 2.4, 2.75 to 2.8 and normal rounding occurs otherwise 2.44 to 2.4, 2.74 to 2.7 and 2.53...
  7. S

    Rounding to the following Sunday

    Racking my brain to get the following to work: =IFERROR(IF(D5=0,"",D5+45),IF(D5="","",D5+7-MOD(D5-1,7))) D5 being the source date that I'm adding 45 days to and then rounding to the following Sunday. Honestly wouldn't mind figuring out the previous Sunday as well. We are trying to set...
  8. M

    rounding in vba

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

    Rounding and Precision Errors

    Hello, In Excel/VBA, I have variables: Q and R. They are both a function of x (complicated formula - but no need to describe it here). D = Q^3 + R^2 So I have: x in column A Q in column B R in column C D in column D At one point, Q^3 so small that D = R^2. I am adding a small number (Q^3)...
  10. C

    ceiling.math rounding up 0 to next/nearest 25

    I'm using ceiling.math to roundup value to nearest 25, but it will not adjust a value of 0 upwards. How do I do this? I don't want any value less than 25.
  11. E

    Rounding Issue

    Hi All, I have three values feeding into three cells on a separate tab (tab 2) Overall Total - 650,281.44 Value 1 - 311126.58 Value 2 - 339154.86 On tab 2, the overall total is recording as £650,281, it has been set to turn yellow if this value does not equate to value 1 and 2 being added so...
  12. C

    Excel Timesheet Rounding

    Hi, I'm trying to develop a timesheet that will round to the nearest 30 minutes and I can't figure out what to use for a formula. Can anyone please help me? First time posting and any I'm looking for any help I can get. Please and thank you!! 1. * Rounding set to 30 minutes, an employee...
  13. S

    Integer rounding issue in VBA

    Hi all I have come across a bit of a problem in my VBA coding which is throwing up a issue. I take out a rounding error in my code with this statement, with EntryList declared as an Integer EntryList = (LastCol - 10) / 2 so if LastCol is 71 then EntryList is set to 30 (ie 71-10 = 61 & 61 / 2...
  14. S

    Index/Match rounding up

    Hello - I used index and match logic to lookup a SKU from a db of skus with 5 separate criteria. The only numbered criteria is rounding a whole number up to the next nearest whole number. I tried a -1 (see below, pulling off of C4) which works like a champ unless my quantity is 1, then it...
  15. M

    Quay For Age Calculate & Round

    Dear All Thanks to note I would like to calculate the age as of today but with rounding up if the age is reached number of months 6 In addition to calculate how many days is remaining to reach the next rounding up Example Birth Date 01-Oct-2000 current age is 17 year and 5 months , so it is...
  16. M

    Rounding Help

    Hi If I have $0.194 how do I get 0.195? Or how do I get the third decimal spot to either be a 0 or 5 depending which is closer?
  17. N

    Combine 2 excel formulas to make one formula for a cell

    HI there :) I currently have this formula in my cell =IF(SUM(I4:CD4)=0,"",H4*14%) and I've read a tip regarding rounding for vat to put this formula in =ROUND(B2*1.14,2). How do I merge these 2 formulas to work in one cell?
  18. R

    Rounding

    So I have a formula written that works for what I am trying to do. I have it rounding to the nearest 500, either up or down, but I need it to round down at the 250 mark, not up. So what I am trying to do is.... 5250 goes to 5000 6380 goes to 6500 7750 goes to 7500 any help is appreciated.
  19. F

    How To Force Other Cells To Adhere To Decimal Point of a Given Value?

    Hey all, I am looking for a way to create a sheet that will adhere to the decimal positions of a given value. I have one cell that I put information into that is referenced in other cells to generate information for me. Sometimes I need this information to have 2 decimal positions (0.00) and...
  20. B

    Using a Cell reference in CEILING.MATH (or MROUND) for the Significance

    I'm using this formula in my spreadsheet =IF(ISBLANK(DI4),CEILING.MATH(DH4,4),"") But can I get the 'significance' reference (example here is multiples of '4') to reference a cell instead that I can use to change the value to round by in ? e.g quickly change from Rounding by 4 to rounding by 5...

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