Change last number to 9

[Laura Lee Day]

I need to change a column of price numbers (eg) 12.84, 9.75, 16.60,etc. so
that the last number is a 9....please help!

 

[Glenn]

I need to change a column of price numbers (eg) 12.84, 9.75, 16.60,etc. so
that the last number is a 9....please help!

=ROUNDUP(A1+0.01,1)-0.01

 

[Ron Rosenfeld]

On Wed, 3 Dec 2008 09:43:00 -0800, Laura Lee Day <Laura Lee

I need to change a column of price numbers (eg) 12.84, 9.75, 16.60,etc. so
that the last number is a 9....please help!

=CEILING(A1+0.01,0.1)-0.01

--ron

 

[Mike H]

Try

=ROUNDUP(A1,0)-0.01

Mike