Rounding currency totals

[dave5000]

Hi All,

I've a spreadsheet with about 500 products and all the prices are like 12.45 or 34.19 or 27.31 etc

I'd like to round the products up to nearest dollar /99 .. example 12.45 would become 12.99 ..34.19 would become 34.99 and so on.

is there a quick formula to do this ?

thanks.

 

[Joe4]

Welcome to the Board!

For an entry in cell A1:

=INT(A1) + 0.99

 

[dave5000]

thanks so much.

 

[Joe4]

You are welcome!