=TEXT(IF(ISERROR(VALUE(LEFT(B24,FIND("/",B24)-1))),0,VALUE(LEFT(B24,FIND("/",B24)-1)))+IF(ISERROR(VALUE(LEFT(C24,FIND("/",C24)-1))),0,VALUE(LEFT(C24,FIND("/",C24)-1)))+IF(ISERROR(VALUE(LEFT(E24,FIND("/",E24)-1))),0,VALUE(LEFT(E24,FIND("/",E24)-1))),"0")&"/"&TEXT(IF(ISERROR(VALUE(RIGHT(B24,LEN(B24)-FIND("/",B24)))),0,VALUE(RIGHT(B24,LEN(B24)-FIND("/",B24))))+IF(ISERROR(VALUE(RIGHT(C24,LEN(C24)-FIND("/",C24)))),0,VALUE(RIGHT(C24,LEN(C24)-FIND("/",C24))))+IF(ISERROR(VALUE(RIGHT(E24,LEN(E24)-FIND("/",E24)))),0,VALUE(RIGHT(E24,LEN(E24)-FIND("/",E24)))),"0")
Retrieved from http://wiki.zeropage.org/wiki.php/곽세환/메모장
last modified 2021-02-07 05:28:44