| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how can i round a dollar amount to the nearest thousand? | Excel Worksheet Functions | |||
| How do I enter a negative dollar amount? | Excel Discussion (Misc queries) | |||
| need help with Index, Match and Countif in the same complicated formula | Excel Discussion (Misc queries) | |||
| finding highest dollar amount | Excel Worksheet Functions | |||
| Conditional Format With SUMIF | Excel Worksheet Functions | |||
Linear Mode
