Rounding Upward

Excel automatically Rounds values ending in 5 away from 0. For example, if you show (or use the ROUND function) on 0.005 and -0.005 to 2 decimals, you'll get 0.01 and -0.01 respectively. So the first is rounded up and the second rounded down. To be consistant, the negative value at -0.005 should round to 0.00. Is there an easy way to get this accomplished when you are uncertain as to whether your value will be negative or positive to begin with? This will cover huge amounts of data in huge amounts of workbooks so I'm trying to stay away from complex formulas, user functions or macros. Thanks

ChemistB

Nope, ROUNDDOWN works the same as truncating and rounds towards zero. So ROUNDDOWN would work on Negative numbers but only if they are exactly 5, e.g. -0.005, -0.002 and -0.007 would all round to 0.00 when I would only want the first two values to be 0.00.

I could make it read

Please Login or Register  to view this content.

but I don't want to change a few hundred spreadsheets that way.

I want the spreadsheets to go by the following rule.
Values where the next significant digit is 5 or higher should round up (i.e. give a higher value). Excel tends to round 5's away from zero which isn't the same thing.

ChemistB