excel help needed

can someone give me a formula so that a value of 4.2 is rounded down to 4.0 and a value of 4.3 is rounded up to 4.5?

I can't work out how to get .5 increments with the ROUND function.

Posted By: Dave in Switzerland on March 5th 2010 at 10:19:41


Message Thread


Reply to Message

In order to add a post to the WotB Message Board you must be a registered WotB user.

If you are not yet registered then please visit the registration page. You should ensure that their browser is setup to accept cookies.

Log in