View Single Post
  #2   Report Post  
Jason Morin
 
Posts: n/a
Default

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