ExcelBanter - Change last number to 9

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Change last number to 9 (https://www.excelbanter.com/excel-worksheet-functions/212389-change-last-number-9-a.html)

Laura Lee Day

Change last number to 9

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

Change last number to 9

Laura Lee Day wrote:
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

Change last number to 9

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

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

Change last number to 9

Try

=ROUNDUP(A1,0)-0.01

Mike

"Laura Lee Day" wrote:

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!

All times are GMT +1. The time now is 11:57 AM.