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

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?

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

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

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

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

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

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.

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

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

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

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

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

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?

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?

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.

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

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

Hi everyone, This is potentially more of a math question, but I'm hoping there is an excel formula that could also help. I'm trying to divide a number of shares by percentages with 14 decimals. The end number of shares needs to be a whole number, however whenever I round I am always left with...

Ok, so i'm doing up sizes and prices for my company and I have a certain lists of values in column AG from AG3 to AG13, in another column I have the offset values. I need a formula for automatically setting the values in column 'F' from F5 to F19 to the next highest value on the list based on...