rounding

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

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

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.

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

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.

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?

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

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

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

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

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

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

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

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

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

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

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

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

Hello, I need to keep my numbers in thousands (ie. 456,798 as 456.798 or 7,000 as 7). In addition I need to have all cells that equal zero be displayed as dashes "-". How do I format my cells? Thanks!

I have a problem copying data from a range via a query. The source range contains several numerical fields precise to 5 decimals to the right of zero. When the routine pastes values into the new sheet however, the numerals are rounded slightly - example $159.45497 somehow becomes $159.45500...