1. A

    specific round figure

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

    IF Statement combined with RoundUp

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

    Custom RoundUp function Error

    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#...
  4. B

    Miltiple if and roundup question

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

    budget spreadsheet with min and max and roundup functions

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

    Formula to round up to the nearest 10 cents

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


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

    Roundup within an IF statement after a condition is met.

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

    IF and ROUNDUP together

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

    How to ROUNDUP an IF Formula

    =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
  11. M

    roundup before multiplied formula??

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

    Roundup If Formula

    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 :-)
  13. Z

    Adding the ROUNDUP function to an existing nested formula containing IFERROR & AVERAGEIF

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

    Round up a figure from VLookUp in VBA userform textbox

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

    percentage round up to nearest decimal point with range

    <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%...
  16. R

    Legitimate Glitch with Match function in Excel

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

    How to round down at 0 but up at >=1

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

    Adding Percentage to Roundup SUM

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

    Formula help !

    I need formula help, I've been trying to figure this out for weeks. Thanks in advance ! Basically I need a formula that will show IF a2 is greater than 0 Roundup to the next whole number IF a2 is a negative, do nothing
  20. A

    Userform to roundup decimals to the nearest 0.25 or 0.5 or 0.75

    Hi everyone I have to roundup an userform decimal places to the nearest 0.25 or 0.5 or 0.75. I use the following formula but it is only to set the decimal place to two digits but cannot round up. Please can anyone help? tBox3 = Format(Round(Val(WordCount) / Range("$C$21") * 1.3, 2), "0" &...

Watch MrExcel Video

This Week's Hot Topics

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