View Single Post
  #14   Report Post  
xlsuser42 xlsuser42 is offline
Junior Member
 
Posts: 5
Default

If your system ends up kicking out a VBA code, try using this formula. Copy and paste it into whatever cell you want. Assume that the number you wish to round is in cell C4.

=IF(ROUND(C4,0)=ROUND(C4-0.1,0),ROUND(C4,0),IF(ISEVEN(ROUND(C4,0)),ROUND(C4 ,0),ROUNDDOWN(C4,0)))