round

Hi I have the following code With Worksheets("Daily Tracking") uValue = Sheets("Training Log").Range("MlsYTDLessLastYr") Select Case uValue Case Is < 0 utext = "less" Case Is = 0 utext = "equal" Case Is > 0 utext = "more"...

Hello, how do I get this string to round down instead of up. =INT(MROUND(B31,1/192)) & TEXT(12*MOD(MROUND(B31,1/192),1),"' - 0 #/##") & """" B31 = 10.81 OUTPUT = 10' - 9 3/4" But I need the out put to be 10 - 9 11/16" I realize that rounding up is the function of MROUND,, I tried other...

HI We have a database that comes up with and error message " Fatal Error" with the message This database has been made rudunant . Needless to say we have had make some workers rudundant just lately . It is a access 97 database , is there anyway we can get into it or should we just write it...

Hi everyone, (New here so go easy on me please). I need to create a fixture list (home and away) that can adjust to different number of players but there's one difficult part: we need everyone to have as many home games (or away games) in a row if possible and all teams must play at the same...

I want to add the ROUND function in the below code. ROUND(L8,0) L8 =IF(I8>=2,2*13500,IF(AND(I8=0,IK8<=2),6800*K8,IF(I8=0,6800*2,IF(I8+K8<=2,(I8*13500)+(K8*6800),IF(I8+K8>2,(I8*13500)+(6800*(2-I8)))))))

I would like to know what would be the formula to either round up or round down a percentage amount. For example I have the following formula: = P3/12*AK3 It calculates original percentage amount which is 5%(cell P3) and divides it by 12 and then multiply by amount of months which in this case...

Hi All, Would be appreciate if there were any Excel sensei here whom can spend a little precious time in drafting a formula for the following case. I would like to round up a figures into a specific value under a certain benchmark, for example: if value = 3.10 and below, i would like excel...

I'm having a math/excel problem. I have a sheet of values. In column A I have package quantities, column B a value that our system says to order. In column C I'd like to produce a value that is the nearest divisible number to what shows in column A. A B C PACKAGE...

Hi there! So I am doing comparison reviews between a system calc and also using VBA to calc % based on criteria. Column T contains tenure. Our system rounds 4.9986 to 5.0, but 4.9900 would round down to 4.0. Is there any way to properly round up / down to nearest whole # based on the above? Ty!!

I need a formula that divides the value of a cell (eg A1) by 3 and if the answer is <1 it must return a value of 0, but if the answer is >1 I want it rounded up to the nearest whole number. So an answer of 1.415 would return 1 and answer of 1.66 would return 2 and an answer of 2.33 would return...

Good morning, I am curious whether it is possible to round a number with asterisks, but keeping those characters in the output? I have a regression tables with many decimals and significance levels ***, ** or * moreover some numbers are in parentheses. Would it be possible/exist a simple way to...

Hey guys. Is it possible to RoundUp the figure returned in my textbox (Price) to be a whole round number? For example, I want '113.2184', to roundup to '114' Price = Application.WorksheetFunction.VLookup(TextBox1.Text, Range("AllProds2"), 10, 0) I don't mind if it rounds up to: '114' or...

Hello, Please advice, how to round a fraction to nearest quarter, for example: <tbody> Value Result 1.1 1.00 1.2 1.25 1.3 1.25 1.4 1.50 1.8 1.75 </tbody> Thanks in advance,

Hello, I'm trying to round off to 0 decimal places a range of cells using VBA. Here is my code Sub roundOff() For Each cell In...

Hello, I am trying to work my way through a script that will take information from one column, concatenate it with another, repeat that for a section of cells, and then repeat all those steps with a different original field, incrementing until a blank field is reached. The data I have looks...

Hello, Need some help trying to figure out why when I create a heat map from different timeframes that I'm only getting ":00" and ":30" and not 8:00am, 8:30am, 9:00am, 9:30am...etc. I'm using the formula =FLOOR(N2,"0:30") to round the timeframe to the half hour. I'm sure using "0:30" is...

Hello, I have a table which shows the engine size necessary for specific horsepowers. Example: 5 hp Size 1 10 hp Size 2 20 hp Size 3 50 hp Size 4 I want to have a cell which displays the proper engine size needed, the issue is that horsepowers can often be values in between the listed...

I have established that writing multoiple if functions such as below I can evaluate the costs of each item. I do think that there must be a simpler solution to my earlier questio (Sum if) and secondly if the quantity is less than the numbers laid out i;e multiples of 720 it returns false...

Hi everyone, I'm new and 1st I would like to say thanks for all experts that help us the newbies as me. I am trying to solve a problem, and I would need your help! I'll start run a project of 20 teams. This would be a matrix with 19 rounds played in 10 time slots. And I would like to create a...

Hi, I have a huge dataset and I need to apply conditional formatting in a very strange and complex way. The data is a mix of hard coded and calculated prices. I need a formula that will apply formatting only if the cell ends with an 5 in the second decimal place (20.55, 5.05, 42.95, etc.). I've...