U E D R , A S I H C RSS

곽세환/메모장

=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")
Valid XHTML 1.0! Valid CSS! powered by MoniWiki
last modified 2021-02-07 05:28:44
Processing time 0.0140 sec