| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how do i round decimal if 2.3=2.5 2.7=2.5 & 2.8=3.0
how do i round decimal if 2.3=2.5 2.7=2.5 & 2.8=3.0
|
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
how do i round decimal if 2.3=2.5 2.7=2.5 & 2.8=3.0
Make sure you have the Analysis ToolPak Add-In loaded...
=MROUND(A1,0.5) Rick "tiffa" wrote in message ... how do i round decimal if 2.3=2.5 2.7=2.5 & 2.8=3.0 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
how do i round decimal if 2.3=2.5 2.7=2.5 & 2.8=3.0
And if you don't want to load the Analysis Tool Pack try this,
=ROUND(A1/0.5,0)*0.5 HTH Martin "tiffa" wrote in message ... how do i round decimal if 2.3=2.5 2.7=2.5 & 2.8=3.0 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
how do i round decimal if 2.3=2.5 2.7=2.5 & 2.8=3.0
=ROUND(A1*2,0)/2
or =ROUND(A1/5,1)*5 Regards, Bernd |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
how do i round decimal if 2.3=2.5 2.7=2.5 & 2.8=3.0
And the reason for your absurdity would be?
Regards Martin "Bernd P" wrote in message ... =ROUND(A1*2,0)/2 or =ROUND(A1/5,1)*5 Regards, Bernd |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Round/Display (HR:MN:SEC) data in decimal HR format for Time C | Excel Discussion (Misc queries) | |||
| Round a repeating decimal from a formula... | Excel Worksheet Functions | |||
| Round a negative decimal | Excel Worksheet Functions | |||
| How do I round last number without a decimal point | Excel Worksheet Functions | |||
| ROUND DATA TO 2 DECIMAL PLACES | New Users to Excel | |||
Hybrid Mode
