roundup

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

Is there a way to ROUNDUP in increments? For example, if A2 is 74 and I wanted the adjacent cell, A3, to round A2 to the closest foot, how would I do it?

How would you round the number 2.33 up to whole number 3 instead of the 2. Power Query's default for 0.33 is to round down and I want to round up. Also, how would you wrap the ROUND function in a formula when adding the values of two columns. <colgroup><col><col><col></colgroup><tbody>...

Hello everyone! Can somebody help me?: I already have the formula: =IF(Z581*200/5000<150,150,Z581*200/5000) I would like to add to this formula a rounding up to 10 (ROUNDUP -1) But, if Z581 is greater or equal to 5200, I wish the result to remain 300 fixed. Thank U very much!

Hi All, I have created userform and want to roundup and round down the entered values If i enter positive value with decimal value it should round down example if i enter 5.01 it should give 5.00 , or for 5.99 should give 5.00 If i enter negative value with decimal value it should round...

I'm getting different totals in excel than I am in calculator Example: Excel 39% * 436.23 = 168.5797 Calculator 39% * 436.23 = 170.1297 What am I doing wrong? Ive tried the ROUND and ROUNDUP function but it never rounds up to 170.1297

I have an interesting question regarding VLOOKUP and ROUNDUP functions use together for numbers between 0.7 and 0.8. As you can see the attached image, numbers greater than 0.7 but less than 0.8 will not work with the ROUNDUP or TRUNC (you can ignore the outcomes for 0.6, 0.7 and 0.8 since this...

I want to use ROUNDUP function with this formula =IF(A10="","",(A10-B10)/A10*100). How it possible. Can someone help me thanks

So I am looking to use the round up function to a whole number. My function is: =(M2*1.2)*0.003 If "=(M2*1.2)*0.003" puts out a number of 25.2. How do I get it to show 26 in the cell automatically? Thanks in advance.

Hello. I would appreciate if someone could help me to combine the SUM function and the round function such that every time I have a sum of 0.6,to round it up to 1. So, for example if I have 1.2 + 1.4, I don't want it to give me 2.6,but 3. Thank you!

Hi In the table below, cells B1 and C1 are 0.2178 AND 0.2199, respectively. The other cells are A2=A A3=B B2=22% C2=22% B3=20% C3=20% <colgroup><col style="width:48pt" width="64" span="4"> </colgroup><tbody> 0.2178 0.2199 A 22% 22% A B...

I have a sheet with the following numbers: 1012 2037 1083 1080 I would like the numbers above the be rounded up to the nearest 5 or 9. So for the example above the finished result would be: 1015 2039 1085 1079 Any help very much appreciated. Thank you.

Hi All, In my latest Excel 2010 workbook I have the following formula: =IF(L13=0,0,IF(F13="Standard",L13,IF(F13="50%",(LEFT(L13,FIND(" ",L13&" ")-1)/2&" "&RIGHT(L13,LEN(L13)-FIND(" ",L13))),IF(F13="x2",(LEFT(L13,FIND(" ",L13&" ")-1)*2&" "&RIGHT(L13,LEN(L13)-FIND("...

Hello, I am trying to build a calculation that rounds up customer requests in increments of 12, based off a set percentage threshold to roundup at. Column A would have percentage % to round up to the next 12, example 0.01% would roundup the next 12 at customer requests >= 12.12 Threshold...

I'm trying to identify the time that employees stoped the work, rounding up the time. Without using VBA is there any formula in excel to this? In this example I show in Column C the final result. If they stop at 05:00, the result should be 05:00. If they stop at 09:01, the result is 10:00. I...

I've got a data dump that must be edited/converted prior to pushing it into a different main frame system. There can be NO decimals in the end result. Here's the challenge: ______Col A____Col B___Col C___Col D____Col E Row1__TOT_____1Q_______2Q_____3Q______4Q_____...

Hi Gurus of Excel, Hopefully my goal is possible... Here's what I'm shooting for: I am working on a spreadsheet to calculate sales tax percentages or sales tax amounts. There are 3 cells involved with my attempted calculations. The first is a cell ("D3") formatted for accounting with 2...

Hello, :) I'd like to roundup a list numbers to the nearest 10, 20, 30 etc... so if a number falls between 1 and 10 will be rounded up to 10 and if a number is between 31 and 40 rounds up to 40. i.e. <TBODY> Numbers Grouped 1 10 3 10 12 20 15 20 23 30 27 30 31 40 38 40 50...

Hi there, I am trying to build a line chart which is based on a data set which will move over the time. Basically, sometimes my source data will have 4 decimals, sometimes 3, sometimes 2, etc. For example, on a set of data which will have a minimum of 1.3012 and a maximum of 1.4512, I would...