Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Round to multiple of 5
I am having trouble with formula to round results to a multiple of 5
Current formula results return the following values and I want to round them to the nearest multiple of .05 Current Desired Result Result $25.61 = $25.60 $25.83 = $25.85 $26.06 = $26.05 $26.28 = $26.30 $26.50 = $26.50 $26.72 =$ 26.70 Appreciate any help. Thank you |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Round to multiple of 5
=MROUND(A1,0.05)
If you get a #NAME error: ToolsAdd-Ins, check Analysis Toolpak -- Kind regards, Niek Otten Microsoft MVP - Excel "JmyCrikitt" wrote in message ... |I am having trouble with formula to round results to a multiple of 5 | | Current formula results return the following values and I want to round them | to the nearest multiple of .05 | | Current Desired | Result Result | $25.61 = $25.60 | $25.83 = $25.85 | $26.06 = $26.05 | $26.28 = $26.30 | $26.50 = $26.50 | $26.72 =$ 26.70 | | Appreciate any help. Thank you | | |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Round to multiple of 5
with you number in a1 maybe this
=ROUND(A1/0.05,0)*0.05 Mike "JmyCrikitt" wrote: I am having trouble with formula to round results to a multiple of 5 Current formula results return the following values and I want to round them to the nearest multiple of .05 Current Desired Result Result $25.61 = $25.60 $25.83 = $25.85 $26.06 = $26.05 $26.28 = $26.30 $26.50 = $26.50 $26.72 =$ 26.70 Appreciate any help. Thank you |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Round to multiple of 5
On Thu, 28 Feb 2008 12:28:06 -0800, JmyCrikitt
wrote: I am having trouble with formula to round results to a multiple of 5 Current formula results return the following values and I want to round them to the nearest multiple of .05 Current Desired Result Result $25.61 = $25.60 $25.83 = $25.85 $26.06 = $26.05 $26.28 = $26.30 $26.50 = $26.50 $26.72 =$ 26.70 Appreciate any help. Thank you =ROUND(A1/0.05,0)*0.05 --ron |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I round numbers to the nearest multiple of 10 or 5? | Excel Worksheet Functions | |||
How do I get MROUND to only round up to the next multiple. | Excel Worksheet Functions | |||
Replacing formula with round multiple times | Excel Discussion (Misc queries) | |||
Can you round up numbers to the nearest multiple of ten? | Excel Worksheet Functions | |||
multiple and round | Excel Worksheet Functions |