Thread: How can I change decimal amounts to end with .95
View Single Post
  #3   Report Post  
N Harkawat
 
Posts: n/a
Default
=IF(A1-INT(A1)0.95,INT(A1)+1.95,INT(A1)+0.95)

"naclu" wrote in message
...
I need to be able to take various dollar amounts and round the change up to
.95 automatically. Is there a way to do this?


Reply With QuoteReply With Quote