| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Rounding up numbers up or down.
RThis is for a price sheet for a new business
I have cells with formulated numbers that I want to round up or down depending to X,X99.95 or X,X49.95. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Rounding up numbers up or down.
Um....did you forget that you posted pretty much the same question to the
same newsgroup around 3 hours ago? (and got 3 responses) *********** Regards, Ron XL2002, WinXP-Pro "Eric Foucrier" wrote: RThis is for a price sheet for a new business I have cells with formulated numbers that I want to round up or down depending to X,X99.95 or X,X49.95. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Rounding up numbers up or down.
You really don't give quite enough information (i.e., where the
breakpoints between rounding up and down should be), but one way might be: =ROUND(A1*2,-2)/2-.05 In article , Eric Foucrier wrote: RThis is for a price sheet for a new business I have cells with formulated numbers that I want to round up or down depending to X,X99.95 or X,X49.95. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Rounding numbers up or down | Excel Discussion (Misc queries) | |||
| how to loose all numbers after decimal (not rounding) | Excel Worksheet Functions | |||
| Rounding numbers to the nearest 5 or 0 | Excel Worksheet Functions | |||
| Rounding numbers to the nearest thousand | Excel Discussion (Misc queries) | |||
| How do I make Excel stop rounding off my numbers that are 16 digi. | Excel Discussion (Misc queries) | |||
Hybrid Mode
