View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
PWS PWS is offline
external usenet poster
 
Posts: 18
Default Rounding Problem


=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!