ExcelBanter - How can I change decimal amounts to end with .95

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - How can I change decimal amounts to end with .95 (https://www.excelbanter.com/excel-worksheet-functions/9036-how-can-i-change-decimal-amounts-end-95-a.html)

naclu

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?

N Harkawat

=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?

N Harkawat

=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?

All times are GMT +1. The time now is 01:58 AM.