| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
I am trying to round a list of numbers (prices) to xx.95. Is the
|
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
I am trying to round a list of numbers (prices) to xx.95. Is the
Try...
=TRUNC(A1)+.95 Hope this helps! In article , "Comexe35" wrote: |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
I am trying to round a list of numbers (prices) to xx.95. Is the
On Fri, 3 Feb 2006 03:46:12 -0800, "Comexe35"
wrote: I don't know about other readers, but when I access this through a newsgroup reader, there's an incomplete header and no message. It would be more useful if you could put your question in the body of the message, rather than trying to just put it in the header. --ron |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
I am trying to round a list of numbers (prices) to xx.95. Is the
Hi Ron,
yes, I've noticed quite a few of them recently. Pete |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| find sum in list of of numbers | Excel Worksheet Functions | |||
| Add specified amount of numbers in a list | Excel Discussion (Misc queries) | |||
| Look up a list of prices | Excel Worksheet Functions | |||
| Does Excel round numbers with a 5 in the tens place? | Excel Discussion (Misc queries) | |||
| How to Round Whole Numbers? | Excel Discussion (Misc queries) | |||
Hybrid Mode
