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