roundup

Hello, i got a little problem to my rounding function, i got an example Aaron = 120,200 Bella = 120,350 Charlie = 120,670 Dean = 120,880 i wanted to round to Aaron = 120,000 Bella = 120,500 Charlie = 120,500 Dean = 121,000 So far, i got into this mess, working formula, but not intended...

Hi, I have a problem that I could use some help solving. I have an Excel workbook that calculate prices. The workbook has about 250 different products. All products are priced based on measurements, both width and height. The user enters the product number, number of products, width and...

I have a question and I hope to get an answer from you. I have grades for some students and I want to make a round figure for the marks in a special way as follows: If the figure in B1 contains 0.1 the round figure should be same 0.1 If the figure in B1 contains 0.2 the round figure should be...

Good morning, I am trying to nest RoundUp Statement within an IF statement for a decimal place. For example if the value is 20.30 I would like it to read 20. If it is 20.50 it can remain the same. Your help is much appreciated.

The following RoundtoUp code is failing in few specific cases as compared with Excel RoundUp: Public Function RoundtoUp( _ ByVal myNum As Double, _ Optional ByVal myFac As Double = 1#) As Double RoundtoUp = (Fix(myNum * CDec(10# ^ myFac)) + IIf(myNum = Fix(myNum * CDec(10#...

Hi All, I have formula with calculating order and after round in up to nearest 100. I have issue with one additional argument - if result is bigger then 0 but smaller then 500 round up to 500. As my minimum order is 500 after this its just 500+100 ect... any suggestions ? :confused...

Hi There, I'm working on my budget spreadsheet, i have a column of numbers generated by our budget formula. I want to add a formula in the next column that will adjust those number to a maximum of $35,000 a minimum of $10,000 and round up everything else to the nearest $100. It is possible to...

Hi Is there a formula to round up a number to the nearest 10 cents? So if the number 0.78 was in cell A2, and it was increased by 10% in B2 to 85.8, it would be rounded up to 90 cents.... <colgroup><col width="64" span="2" style="width:48pt"> </colgroup><tbody> Number 10% 0.78...

Hi Guys, I've been trying to roundup the result of this formula but i can't seem to make it work. Can anybody please help me. =IF($B8="","",(VLOOKUP($B8,'Type D Box Col Data '!$C$4:$H$260,5,0)*2)+1+(2*C8)+2) Thanks in advance, bnkyaong.

Hi Everyone, I'm new to this group and not well trained with Excel, I've spent my morning looking at formulas trying to find the solution. Here is the formula I have written, which works. I need to show a value of 7 if Z2 is less than 0.5, but I need it to roundup Z2 to the next whole number...

I only want to apply the ROUNDUP function when N8<O8, otherwise return N8. This formula returns N8 regardless, even if I swap the < for >. Can someone help with the correct syntax? =IF(N8<O8,ROUNDUP((O4*N5),0),N8)

=IF(B5=0.375,(C5*D5)+E5+(IF(B5=0.375,F5*0.057))+(IF(B5=0.375,G5*0.094))+(IF(H5="X",0.328125,0))+(IF(I5="X",0.453125,0)),0) How do I get this formula to ROUNDUP to the nearest 0.25? Thanks

I'm sure this is easy for somebody.. How do I multiply two numbers rounded up to the next whole number... =(A1*B1) Cell values: 20.5 x 30.25 = 620.125 ...not like this<not like="" this<not="" this="" (="A1*B1)=" 620.125 but lke this... 20.5 x 30.25 (21 x 31) = 651 651 is the answer I'm...

I am looking to roundup if the number in a cell ends higher than 0.2 and round down if its lower than 0.2 so for example 1.2 would round to 2 and 1.1 would round down to 1. Have tried everything with ROUNDUP and IF but can't work it out. Any help much appreciated :-)

Hi all, I have the following formula and I need to add the ROUNDUP function to it so that it rounds up anything greater than 5 after the decimal point. Where do I add the ROUNDUP function to this formula please. =IFERROR(AVERAGEIF('Data Raw'!$T$4:$T$136,"Commercial",'Data Raw'!$U$4:$U$136),0)...

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

<tbody> Salary 11% Payroll Website Result RM 3460 RM 380.60 RM 381.00 RM 3470 RM 381.70 RM 383.00 RM 3480 RM 382.80 RM 383.00 RM 3490 RM 383.90 RM 385.00 </tbody> dear all, I'm doing a manual excel formula payroll therefore I faced an issues that the calculation of 11%...

How do I let Microsoft know that there's a glitch in Excel 2010 that needs fixing? This has been replicated across three different computers now. I don't know where to upload the file so I'll just copy paste the results and then the equations for the proof below if you wish to replicate. You...

I have a question about rounding. The exact numbers displaying in the cell in question will vary depending on the value of other cells, but to cite a specific example, I'll use the following numbers. The formula in the cell is returning $322.8703689...., which is correct. It is displaying...

Hi Everyone, I'm currently using this formula to add and roundup two values: <style type="text/css">p.p1 {margin: 0.0px 0.0px 0.0px 0.0px; font: 12.0px Times}span.s1 {font: 12.0px Arial; color: #0433ff}span.s2 {font: 12.0px Arial}</style>=ROUNDUP(SUM(A1:B1),0) But now I'm stuck trying to add...