How can I change decimal amounts to end with .95

naclu · Jan 11, 2005

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?

N Harkawat · Jan 11, 2005

=int(A1)+0.95

N Harkawat · Jan 11, 2005

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