Rounding to two even decimal places

N

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

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

Thanks for your help!
 
S

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top