rounding issues

Hello - I know this sounds strange, but I am looking for a way to condition data in spreadsheet cells to round down at 5 and round up at 6. Example: $2.245 would be $2.24 AND $2.246 would be $2.25. Is this even possible as it seems all of rounding functions in Excel and based on traditional...

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

Morning guys, I have a column of values containing 3050 rows. Each row has a value from 0 - 50. The majority of cells are 1's, 2's etc. I need to create two new columns to the left, one of which has 50% of the value, and the next having 30% of the value. The trouble is, I've done previous...

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

Greetings. I have rounding issue. I'm working with whole numbers, and rounding into millions. For example, the whole numbers are (bold is total): <colgroup><col></colgroup><tbody> (2,339,425) 8,260,205 3,222,786 9,143,566 </tbody> Rounded (using the ROUND function): (2.3) 8.3 3.2...

Import to array, export from array. first part of my code... at the bolded msgbox, the data is unrounded, but in the cell it is rounded. Makes me think it is more an excel problem than VBA. The cells are formatted to accept up to 4 decimals, but it is always rounding to 2. can't figure out...

Hi All, I am trying to get excel to calculate a value and round it to 2 decimal places before entering into a separate worksheet. I have all of it working bar the rounding part. I cant seem to figure out how to get VBA to round the value to 2 decimal places before entering into the worksheet. I...

I've been learning how to use conditional formatting and decided to apply it to my bank account records that I have stored in Excel. I wanted to check for missing sections in my statement in case I lost any transactions when exporting the data in little chunks at my internet banking website...

I work with currency in Excel and I need a way for Excel to round to the nearest hundredth without excluding decimal places. What I mean is, when you take the equation $123.50*0.8717 the answer is $107.65495. When you use the formula ROUND($123.50*0.8717,2) the answer is $107.65. However, it...