Home |
Search |
Today's Posts |
#2
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
"PWS" wrote...
.... =TEXT(2.753;"0.00")&" / "&TEXT((2.848-INT(2.848))*100;"00") Obviously on the workbook the values as cell references Using the follwoing example I get a 'wrong' result. 2.850 - 2.995 should be shown as 2.85 / 00, but is shown as 2.85 / 100. I do not understand how 995 becomes 100 rtaher than 00, when the format requested is "00", but it does. Well, it's not 995, it's 99.5, and it rounds up to 100, and 100 in "00" format displays as 100. If you want to it to round to be 00, you need to toss in ROUND and MOD calls. =TEXT(A2,"0.00 \/ ")&TEXT(MOD(ROUND((B2-INT(B2))*100,0),1),"00") |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Rounding Problem | Excel Discussion (Misc queries) | |||
Rounding off problem..! | Excel Worksheet Functions | |||
Averaging/Rounding Equation Problem | Excel Worksheet Functions | |||
Averaging and Rounding problem | Excel Worksheet Functions | |||
Simple Rounding Problem | Excel Discussion (Misc queries) |