| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do I round to the nearest 25 cents in Excel?
How do I round to the nearest 25 cents in Excel?
|
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How do I round to the nearest 25 cents in Excel?
one way
number is in A1 =ROUND(A1/25,2)*25 formatted to two fixed decimals -- Greetings from New Zealand " wrote in message ... How do I round to the nearest 25 cents in Excel? |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How do I round to the nearest 25 cents in Excel?
Try this:
With A1: (a number) B1: =ROUND(A1/0.25,0)*0.25 Does that help? *********** Regards, Ron XL2002, WinXP " wrote: How do I round to the nearest 25 cents in Excel? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Round to the nearest 9 cents | Excel Discussion (Misc queries) | |||
| Rounding to the nearest 50 cents | Excel Discussion (Misc queries) | |||
| Currency Rounding to nearest 5 cents | Excel Discussion (Misc queries) | |||
| Rounding to nearest 5 cents in excel | Excel Worksheet Functions | |||
| I am trying to round up to the nearest 25 cents | New Users to Excel | |||
Linear Mode
