round

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

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

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

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

I need help with roundup in an if statement. =ROUNDUP(MONTH($G7)/3,0) I've tried everything that I can think of with no luck. Any help would be appreciated. I need Quarter come from Date but if there is not date formula show 0 not value.

<colgroup><col><col span="2"></colgroup><tbody> Barcode Price Result 110022002095 43.7535 45 2200000000019 78.75 80 2200000000026 105 105 2200000000033 105 105 2200000000040 105 105 2200000000057 105 105 2200000000064 175.0035 175 2200000000071 52.5 55 2200000000095 15.75 16...

Hi, I’m having a problem with the following tract of VBA. It is intended that it should loop round until a window with a particular title (as held in string wtit) is detected. It works ok if the said window already exists before running the code, but it fails on the SECOND time round the loop...

I'm struggling to work out a formula to round off time to the nearest 15 minutes. Basically the numbers are timesheet entries and they need to be rounded in the following format: <tbody> Current Format Desired Output 02:19:04 2.5 01:37:00 1.5 03:55:23 4 </tbody> I've been able to...

I have this code that almost works, but has one issue. I think i know why, but dont know how to fix it. As dates are entered elsewhere, G11 counts them. When G11 = G16, it throws up the MsgBox. So far so good. When I hit 'OK' on the MsgBox, Step 1 occurs (saves the file), but then the MsgBox...

Hello I want to numberformat with many columns at one go Can i ws.Columns(3, 5, 9, 11, 23, 27).NumberFormat = Trim(Replace(Format(String(Len(Int(Cell.value)) - 1, "#"), " @@\\,@@\\,@@\\,@@\\,@@\\,@@\\,@@0"), " \,", "")) & ".00" Also Cell.value in red requires proper syntax Will the above...

Is it possible in the same formula to Rank and Round together? I have the following formula but it is returning #N/A. I assume this is because the whole reference is not rounded which leads me to believe this is not possible to do in one step. However, I thought someone may know of a workaround...

Hi I have an audit matrix document which calculates %age scores for multiple sites. The score should always show a full number (i.e 80%, 90%, etc...), and I am happy for standard rounding to apply (i.e round down for .4 and below, round up for .5 and above) However, I don't want this to apply...

Hi, What kind of excels functions that involved for setting up an effective formula to check and see if the following betting strategy would work for every 9,500 or so hands, and I'm using excel 2007: +10 +20 +10 -20 +20 +10 -20 -30 -70 -150 -10 -30 -70 +150 +10 -10 -30 +70 -10 +30 -10...

Hi, What kind of excels functions that involved for setting up an effective formula to check and see if the following betting strategy would work for every 9,500 or so hands, and I'm using excel 2007: +10 +20 +10 -20 +20 +10 -20 -30 -70 -150 -10 -30 -70 +150 +10 -10 -30 +70 -10 +30 -10...

Hello, If my sum cell equals 25.13, and I want that cell to round up to 26.00, what formula would I use?

Col Col A Col B <tbody> First name Last name Mrs Brown, Lisa Tom Smith Fred Jones Mr Delph, Clive Stuart Round </tbody> Any idea how I would merge the two columns in order that I can read this as Mrs Lisa Brown / Tom Smith / Fred Jones / Mr Clive...

In my code, I run into values of a variable (tdur) representing duration (in hours) . These are some examples: 0.53 1.53 2.11 1.06 1.32 2.64 0.26 I would like to round these to the nearest 30 minutes. So, with these example: 0.5 1.5 2.0 1.0 1.5 3.0 0.5 I thought it was more simple than it is.

I am working on a project where I have to reference different tabs of many rounds. I have formatted my index and match searches for the first round, but found that I was doing a lot of hard coding when trying to change each of the formulas for the "Round 2" tab. Is there a way that I can...

Hi, I am trying to combine round and sumifs in one statement but its not liking what I am doing . Is there an easy way to do this? =ROUND(SUMIFS('2.3 Lines'!$T:$T,'2.3 Lines'!$F:$F,"Service"),0) Thanks, Sharon

Need to have the following formula round up anything over .0. Any help is appreciated. =IFERROR((D2*24)/9,"")