View Single Post
  #6   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(A2,"0.00 \/ ")&TEXT(MOD(ROUND((B2-INT(B2))*100,0),1),"00")


Unless I am implementing something wrongly, your formula works for the
problem example but does not produce the required result for the other
example!


I screwed up. The second argument to MOD should be 100, not 1.

=TEXT(A2,"0.00 \/ ")&TEXT(MOD(ROUND((B2-INT(B2))*100,0),100),"00")