Rounding to two even decimal places
 

I need some help with a formula that will round a number to two decimal
places, but the two decimal places must be an even number.

For example:
$12.115 through $12.134 would be $12.12
$12.135 through $12.154 would be $12.14

Would prefer not to use the ISEVEN formula to avoid add-in problems for
different users of my spreadsheet.

Thanks for your help!

Rounding to two even decimal places
 

Subtract .005, divide by 2, round, then double
=round(((a1-.005)/2),2)*2

"needhelp" wrote:

I need some help with a formula that will round a number to two decimal
places, but the two decimal places must be an even number.

For example:
$12.115 through $12.134 would be $12.12
$12.135 through $12.154 would be $12.14

Would prefer not to use the ISEVEN formula to avoid add-in problems for
different users of my spreadsheet.

Thanks for your help!

Rounding to two even decimal places
 

Brilliant -thanks so much!

"bpeltzer" wrote:

Subtract .005, divide by 2, round, then double
=round(((a1-.005)/2),2)*2

"needhelp" wrote:

I need some help with a formula that will round a number to two decimal
places, but the two decimal places must be an even number.

For example:
$12.115 through $12.134 would be $12.12
$12.135 through $12.154 would be $12.14

Would prefer not to use the ISEVEN formula to avoid add-in problems for
different users of my spreadsheet.

Thanks for your help!

Rounding to two even decimal places
 

Tue, 15 May 2007 10:54:01 -0700 from needhelp
:
I need some help with a formula that will round a number to two decimal
places, but the two decimal places must be an even number.

For example:
$12.115 through $12.134 would be $12.12
$12.135 through $12.154 would be $12.14

Put =ROUND( , 2)
around your calculation.

--
Stan Brown, Oak Road Systems, Tompkins County, New York, USA
http://OakRoadSystems.com/