Convert whole number to rounded decimal?

[H1SOKA]

Hi guys,

I have a spreadsheet which calculates prices based on customer order quantity. These prices are then uploaded to a website.

However, the current spreadsheet outputs prices such as $21.25, $9.67, $10.11 etc.

What I'd like instead, is for these prices to be rounded up or down to their lowest dollar and cent integers.

For example: $21.25 would become $20.99; $9.67 would become $9.99; $10.11 would be $9.99 etc

Is there a macro or formula I can use that will do this? Anything below $0.50 should be rounded down, and anything over $0.50 should be rounded to the closest 99 cents.

Thanks for your help.

 

[pgc01]

Hi

Try:

=INT(A1+0.5)-0.01

 

[H1SOKA]

Hi

Try:

=INT(A1+0.5)-0.01

Works great. Thanks!

 

[pgc01]

You're welcome.