Hi
Check the method i used
B1 and c1 contains fraction part
Divide the numbers (D1)
Get the integer (E1)
Get the remainder (F1)
Get the fraction part (Fraction format)![]()
=B5-C5*E5
Parse the G5 to get the required (H5)![]()
=f5/c5
You can make a bigger formula of these steps![]()
=RIGHT(TEXT(G5,"?/?"),1)*E5+LEFT(TEXT(G5,"?/?"),1) & "/" & RIGHT(TEXT(G5,"?/?"),1)
See attached for example
Regards
Bookmarks