Thread: HOW DO I FORMULATE A CELL TO ROUND $5.82 TO $5.85
View Single Post
  #4   Report Post  
Ron Coderre
 
Posts: n/a
Default
Try this:
=TRUNC(A1*10)/10+IF((MOD($A1,0.1)+0.01)<=0.06,0.05,0.09)

Does that help?

Regards,
Ron

Reply With QuoteReply With Quote