How can I change decimal amounts to end with .95

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?

=int(A1)+0.95


"naclu" <[email protected]> wrote in message
news:[email protected]...
>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?

=IF(A1-INT(A1)>0.95,INT(A1)+1.95,INT(A1)+0.95)

"naclu" <[email protected]> wrote in message
news:[email protected]...
>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?