Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I have a requirement to displace the follwoing pair of data items as
shown: A simple example is: 2.753, 2.848 ....... 2.75 / 85 I have the following formula: =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. Can anyone think of a way to achieve what I am looking for? |
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) |