How can I change decimal amounts to end with .95

Guest · 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)

Formula to round off number to .95 cents	3	Oct 12, 2009
Can I round prices to end in .95?	2	Jan 13, 2009
How to get sum totals to auto calculate when changes made?	1	Apr 13, 2008
Extracting dollars and cents	1	Mar 28, 2007
How do I automatically convert $1,234,555,678.05 to $1.5 billion?	2	May 23, 2006
Run Windows 95 in Ubuntu As An Electron App	1	Aug 28, 2018
rounding decimals to nearest quarter	4	Jul 3, 2008
Cell for Changing Multiple Values in other columns	2	Dec 12, 2008

Ask a Question