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...
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...
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
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" &...
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 MrExcel.com.
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 "mrexcel.com".
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.