| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Rouding to Multiple Decimals
hi Advice required for rouding values between below ranges: 10.00 - 10.24 = rounded down to 10 10.25 - 10.49 = rounded up to 10.5 10.5 - 10.74 = rounded down to 10.5 10.75 - 10.9 = rounded up to 11 regards Essa |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Rouding to Multiple Decimals
Esssa wrote:
hi Advice required for rouding values between below ranges: 10.00 - 10.24 = rounded down to 10 10.25 - 10.49 = rounded up to 10.5 10.5 - 10.74 = rounded down to 10.5 10.75 - 10.9 = rounded up to 11 regards Essa =ROUND(A1*2,0)/2 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Rouding to Multiple Decimals
With your number in A1, try this:
=CEILING(A1-0.24,0.5) Copy down as required. Hope this helps. Pete On Oct 23, 1:52*pm, Esssa wrote: hi Advice required for rouding values between below ranges: 10.00 - 10.24 = rounded down to 10 10.25 - 10.49 = rounded up to 10.5 10.5 - 10.74 = rounded down to 10.5 10.75 - 10.9 = rounded up to 11 regards Essa |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Rouding to Multiple Decimals
What was wrong with the answers you recieved in your earlier post??
=ROUND(A1/0.5,0)*0.5 =MROUND(A1,0.5) "Esssa" wrote in message ... hi Advice required for rouding values between below ranges: 10.00 - 10.24 = rounded down to 10 10.25 - 10.49 = rounded up to 10.5 10.5 - 10.74 = rounded down to 10.5 10.75 - 10.9 = rounded up to 11 regards Essa |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel extending result to multiple decimals | Excel Worksheet Functions | |||
| Sorting Numbers with Multiple Decimals (cont.) | Excel Discussion (Misc queries) | |||
| Sorting Numbers with Multiple Decimals | Excel Discussion (Misc queries) | |||
| Rouding up times. e.g. 7:33 --> 7:35 | Excel Discussion (Misc queries) | |||
| Rouding Dates to beginning of a week | Excel Discussion (Misc queries) | |||
Linear Mode
