Thread
:
Rounding Problem
View Single Post
#
4
Posted to microsoft.public.excel.worksheet.functions
PWS
external usenet poster
Posts: 18
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!
Reply With Quote
PWS
View Public Profile
Find all posts by PWS