| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
want to round a number to the nearest quarter 0.25-0.50-0.45-0.00
can somebody help?
|
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
want to round a number to the nearest quarter 0.25-0.50-0.45-0.00
=ROUND(A2*4,)/4
with your number in A2 for future posts put the question in the body of the message as well -- Regards, Peo Sjoblom "Vangelis" wrote in message ... can somebody help? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
want to round a number to the nearest quarter 0.25-0.50-0.45-0.00
If you have the Analysis ToolPak add-in installed:
=MROUND(A1,0.25) Otherwise: =ROUND(F1/0.25,0)*0.25 Is that something you can work with? -------------------------- Regards, Ron (XL2003, Win XP) Microsoft MVP (Excel) "Vangelis" wrote in message ... can somebody help? |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
want to round a number to the nearest quarter 0.25-0.50-0.45-0.00
One way:
=ROUND(A1*4,0)/4 In article , Vangelis wrote: can somebody help? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can you round numbers to the nearest quarter (i.e. .63=.75) | Excel Worksheet Functions | |||
| How do I round time to the nearest quarter of an hour | New Users to Excel | |||
| how do I round 3.30 to the nearest quarter. 3.30=3.25 | Excel Worksheet Functions | |||
| round numbers to the nearest quarter? | Excel Worksheet Functions | |||
| Round time to nearest quarter hr | Excel Worksheet Functions | |||
Linear Mode
