Need to change rounding so $192.50 is $192, not $193. And, $192.00 would need to stay $192.

[lmbarnett]

Hi all,

I'm working on a spreadsheet of income figures for a particular program (like, a public support program, not a computer program). In this program, we've got certain rules about rounding numbers. To keep it short, I need a way to make a $192.50 into $192, not $193. And I need $192.00 to stay $192. I need to be able to do this for both a calculated result via formula and a number that's simply typed in.

I hope this is clear.
I'm using Windows 7 and Excel 2010.

Thank you, thank you! The forum has already helped me turn negative numbers into just 0's.

 

[Gerald Higgins]

If you are 100% sure that the number will ALWAYS be $#.50 or $#.00, then
=INT(A1)
is probably the easiest and shortest.

You could also use
=ROUNDDOWN(A1,0)

and several of the other suggestions should work too.