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