=IF(MOD(A1,1)=0.5,A1,INT(A1)+(MOD(A1,1)=0.6)*1)

You don't actually need the *1 because the addition of the INT and MOD
functions will convert the Boolean.

=IF(MOD(A1,1)=0.5,A1,ROUND(A1,0))

will also work

Regards

Sandy
--
to e-mail direct replace @mailinator.com with @tiscali.co.uk


"Jason Morin" wrote in message
...
If you mean greater than or *equal* to .6, try:

=IF(MOD(A1,1)=0.5,A1,INT(A1)+(MOD(A1,1)=0.6)*1)

HTH
Jason
Atlanta, GA

-----Original Message-----
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?
.