簡化分數 (9690)

C2=LEFT(B2,FIND("/",B2)-1)/GCD(LEFT(B2,FIND("/",B2)-1),MID(B2,FIND("/",B2)+1,9))&"/"&MID(B2,FIND("/",B2)+1,9)/GCD(LEFT(B2,FIND("/",B2)-1),MID(B2,FIND("/",B2)+1,9))

D2 (定義通用)=LEFT(B2,FIND("/",B2)-1)/MID(B2,FIND("/",B2)+1,9)