replace last digit in a dollar amount
 

I am trying to create a Price Book with SRP's. I need to have all prices end
with a 9. How do I replace the last digit?

replace last digit in a dollar amount
 

Assuming your prices are all integer (cents or pence), try this:

=ROUNDUP(A1,-1)-1

assuming your prices start in A1. Copy down as necessary.

Hope this helps.

Pete


Louise wrote:

I am trying to create a Price Book with SRP's. I need to have all prices end
with a 9. How do I replace the last digit?

replace last digit in a dollar amount
 

I would be inclined to round it to the 10 cent mark and then just subtract a
penny. So something like this perhaps

=ROUNDUP(A1, 1)-0.01
or
=ROUND(A1, 1)-0.01
--
HTH...

Jim Thomlinson


"Louise" wrote:

I am trying to create a Price Book with SRP's. I need to have all prices end
with a 9. How do I replace the last digit?