View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Harlan Grove[_2_] Harlan Grove[_2_] is offline
external usenet poster
 
Posts: 1,231
Default Rounding Problem

"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")