Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Can I round prices to end in .95?
I'm preparing a business price list. It reads a cell from my working cost
sheets. On the price page can I round prices to end in .95? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Can I round prices to end in .95?
Hi,
Try =INT(A1)+0.95 Mike "Tire Guy" wrote: I'm preparing a business price list. It reads a cell from my working cost sheets. On the price page can I round prices to end in .95? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Can I round prices to end in .95?
You don't really give enough info, so I will assume you want whatever price
is in cell A1 to round to the NEAREST X.95. That formula would be: =ROUND(A1,0)-0.05 To always round UP to the next X.95, try: =CEILING(A1,1)-0.05 -- "Actually, I AM a rocket scientist." -- JB Your feedback is appreciated, click YES if this post helped you. "Tire Guy" wrote: I'm preparing a business price list. It reads a cell from my working cost sheets. On the price page can I round prices to end in .95? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
prices | Excel Discussion (Misc queries) | |||
I am trying to round a list of numbers (prices) to xx.95. Is the | Excel Worksheet Functions | |||
Pricing - how to round up various prices to .95 | Excel Discussion (Misc queries) | |||
Use a multiplier to change List Prices to Net prices | Excel Worksheet Functions | |||
How do I ROUND() round off decimals of a column dataset? | Excel Worksheet Functions |