Your criteria are not clear. What do you want .599999999 to return?
What about .499999999? What about .400000001? Do you care that if you
round .54 to .5 but .46 to .4 that you will be introducing bias into
your rounded values?

Jerry

Scott wrote:

i would like to use the round function so that if the 1st
decimal place is .6 it rounds up and <.4 it rounds down,
but does nothing if =.5

can this be done?