rounding

  1. D

    Rounding shares to whole numbers

    Hi everyone, This is potentially more of a math question, but I'm hoping there is an excel formula that could also help. I'm trying to divide a number of shares by percentages with 14 decimals. The end number of shares needs to be a whole number, however whenever I round I am always left with...
  2. E

    Formula for rounding using a specific list

    Ok, so i'm doing up sizes and prices for my company and I have a certain lists of values in column AG from AG3 to AG13, in another column I have the offset values. I need a formula for automatically setting the values in column 'F' from F5 to F19 to the next highest value on the list based on...
  3. U

    Can I prevent rounding with the Format command?

    I need to return a value with five decimal places. If a value is 1.999999, the Format command returns 2. var = 1.999999 debug.print Format(var, "#.00000") Returns 2 I need it to return 1.99999 Mathematically I can change the value but there has got to be a better way. Can rounding be...
  4. S

    Rounding a number that is entered into a cell to the nearest thousand.

    Hi, I have a cell that someone will be manually typing a number into. After they enter the number, I need that number to be rounded to the nearest thousand. Since this cell is one that will be manually typed into, this automatic rounding of whatever number they put into the cell has to be done...
  5. E

    Stop rounding quotient from rounding when using a counting formula.

    I have this formula, =quotient(A1,(counting(A2:A6,"*")) that I am using to split a tip dollar amount. My problem is that it seems to just return an answer that is rounded to the dollar even though I have it going out 2 decimal places. I need it to stop rounding. Please help.
  6. X

    Rounding in VBA

    Hello, I am working on a spreadsheet that I have a goal seek function to find the optimal number of units based on certain parameters. My problem is that I need to round these numbers up or down depending on which one it is. I found a solution that mostly works but sometimes it does not act...
  7. E

    ROUNDUP Formula in Same Cell

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

    Rounding large data range:

    I have a large worksheet full of long numerical values (e.g 5.6467756) after removing formulas via (Copy+Paste Special+Values) which ALL need to be rounded to 2 d.p., say 5.65. I only need 5.65 in the cell after the operation. A way round to apply rounding to a whole range at once?
  9. C

    Assistance Rounding Retail aprices in Excel

    Hi all, first time forum reader. Currently working on some price changes in a retail environment. Trying to figure out the best way to apply the following rounding rules: <tbody> IF UNDER 10.00 - ROUND DOWN TO CLOSEST .09 (UNLESS .09 OR .19 - THEN ROUND DOWN TO CLOSEST .99) IF BETWEEN 10.01...
  10. P

    Averaging Ratios from a drop down list. Be gentle.. Amateur here..

    So I have 4 catagories for care provided to a disable adult, for accessing the community there could be a 1:1 staffing ratio, for personal care this could be 2:1. For group work this staffing ratio could be 1:10. I need 4 areas to have a drop down selection of a a ratio. Then I need to...
  11. M

    Need help rounding down results of a formula

    I need help adding round down to an existing formula. Any one out there know how to add? I want to perform the following calculation & round down the results in the same cell. For example. . . my formula in B15 is =D13*F13/1095. Right now the result showing in B15 is 58.35342466. I want the...
  12. B

    Pivot Table Rounding Limitations / Solutions

    I have a sheet that takes several items and after it calculates, info gets pulled over into a pivot table for easy breakdown for billing. The problem is that the pivot table rounds when it receives the data, regardless of whether I want it to or not. This causes an occasional penny to be...
  13. J

    Excel floating point representation - two 6s are not the same!

    I'm really struggling when trying to understand how Excel deals with number representation. It would appear that (1.2 / 0.2) and (12 / 2) are NOT the same. Although both results appear as '6' in the formula bar, I noticed that in a pivot table, Excel 2013 was not summarising both values...
  14. A

    Advanced Rounding

    Hello everyone, I'm having a difficult time figuring this problem out. I'm trying to round up and down numbers depending on their decimal value. Basically if decimal is equal/over .65, then round up to the next whole number if decimal is between 0.25 and .65 then enter 0.5 and finally if...
  15. E

    rounding formula

    In this rounding formula =Round(($D$6*C7),2) what do the $ stand for or do?
  16. L

    Rounding macro

    Hi all, I have a worksheet that pulls in data from another source that has 7+ decimal places so when I summarize the data I have balancing issues with the rounding. Does anyone have a macro that will take the data in cells D34:E49, G34:HE49, J34:K49, M34:N49, round and absolute the numbers to...
  17. D

    Rounding trouble: Column must sum to 100%

    I have a manual process I would like to automate. Every time that I trade a portfolio I need to take balances after any changes, and round to the nearest 0.01% (two decimal places). The problem is, using your typical =ROUND(,4) formula for each row in the column, you end up with + or - 0.01% to...
  18. S

    Rounding problem

    If I have numbers under 10, then I want to rounding to 1. If above 10, then should rounding 0. How can I solve this in excel? So an example: 12 16 18 Average 15 and not 15,3 6 7 6 Average 6,3 and not 6
  19. S

    "Gross to Net" Rounding Formula

    Hello, I am in search of a formula that will take the gross number of contracts my company is awarded per month, apply a cancellation rate of 10%, and if the net number is then greater than X.5 awards, round up to the next number. For example, if we are awarded 15 gross contracts in January...
  20. J

    Question on Custom Number Formats - Displaying Financials in Thousands

    Hello, I have question on displaying numbers in thousands for presenting financial information. I prepare the spreadsheets using source data without rounding, and would then like to prepare the results in thousands on select pages. I understand the basics of how to display figures in...

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 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.
Go back
Back
Top