Change last number to 9

  • Thread starter Thread starter Laura Lee Day
  • Start date Start date
L

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!
 
Laura said:
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!
Click to expand...

=ROUNDUP(A1+0.01,1)-0.01
 
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!
Click to expand...

=CEILING(A1+0.01,0.1)-0.01

--ron
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Sumif for unique values 10
Sumproduct error 2
end zero in a cell 3
Wordey Books. 5
Round 4
Generating a cut list 11
Sort column beginning with blank? 1
With F1 value, look at A, if match or partial match return B 5

Back
Top