Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
round to ,5
Hi,
When a value is 60.12 I want it to be rounded to 60.00 a value 60.45 to 60.50 a value 60.57 to 60.50 a value 60.85 to 61.00 does somebody know s how? Thanks JP |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
round to ,5
Hi
=Round(A1*2,0)/0.5 Also see: http://www.xldynamic.com/source/xld.Rounding.html -- Regards Frank Kabel Frankfurt, Germany "Jean-Paul De Winter" schrieb im Newsbeitrag ... Hi, When a value is 60.12 I want it to be rounded to 60.00 a value 60.45 to 60.50 a value 60.57 to 60.50 a value 60.85 to 61.00 does somebody know s how? Thanks JP |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
round to ,5
one way
=(ROUND(A1*2,0))/2 Regards Bill K "Jean-Paul De Winter" wrote in message ... Hi, When a value is 60.12 I want it to be rounded to 60.00 a value 60.45 to 60.50 a value 60.57 to 60.50 a value 60.85 to 61.00 does somebody know s how? Thanks JP |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
round to ,5
Jean-Paul,
Try this =ROUND(A1/5,1)*5 Neil. "Jean-Paul De Winter" wrote in message ... Hi, When a value is 60.12 I want it to be rounded to 60.00 a value 60.45 to 60.50 a value 60.57 to 60.50 a value 60.85 to 61.00 does somebody know s how? Thanks JP |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
round to ,5
JP
use: =MROUND(A1,0.5) Regards Trevor "Jean-Paul De Winter" wrote in message ... Hi, When a value is 60.12 I want it to be rounded to 60.00 a value 60.45 to 60.50 a value 60.57 to 60.50 a value 60.85 to 61.00 does somebody know s how? Thanks JP |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Round Up and Round Down Time | Excel Worksheet Functions | |||
Round up or down to $X.X9 or up to $X.X5 | Excel Worksheet Functions | |||
Round Up/Down ? | Excel Worksheet Functions | |||
Round hh:mm:ss to whole hh:mm | Excel Worksheet Functions | |||
How do I ROUND() round off decimals of a column dataset? | Excel Worksheet Functions |