Rounding to two even decimal places

[Guest]

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!

 

[Guest]

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

 

[Guest]

Brilliant -thanks so much!

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

 

[Stan Brown]

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.