낙서장

EXCEL function

아르비스 2016. 2. 23. 15:57

=IF(ISBLANK(D214),"","server ioffice_search01 "&CONCATENATE(D213,":7001")&" check")

& "" &CHAR(10)& "" &IF(ISBLANK(E214),"","server ioffice_search02 "&CONCATENATE(E213,":7001")&" check")

& "" &CHAR(10)& "" &IF(ISBLANK(F214),"","server ioffice_search02 "&CONCATENATE(F213,":7001")&" check")

& "" &CHAR(10)& "" &IF(ISBLANK(G214),"","server ioffice_search02 "&CONCATENATE(G213,":7001")&" check")

& "" &CHAR(10)& "" &IF(ISBLANK(H214),"","server ioffice_search02 "&CONCATENATE(H213,":7001")&" check")

& "" &CHAR(10)& "" &IF(ISBLANK(I214),"","server ioffice_search02 "&CONCATENATE(I213,":7001")&" check")

& "" &CHAR(10)& "" &IF(ISBLANK(J214),"","server ioffice_search02 "&CONCATENATE(J213,":7001")&" check")

& "" &CHAR(10)& "" &IF(ISBLANK(K214),"","server ioffice_search02 "&CONCATENATE(K213,":7001")&" check")


=IF(ISBLANK(D214),"","server ioffice_search01 "&CONCATENATE(D213,":"&D214)&" check")

&""&CHAR(10)&""&IF(ISBLANK(E214),"","server ioffice_search02 "&CONCATENATE(E213,":"&D214)&" check")

&""&CHAR(10)&""&IF(ISBLANK(F214),"","server ioffice_search03 "&CONCATENATE(F213,":"&D214)&" check")

&""&CHAR(10)&""&IF(ISBLANK(G214),"","server ioffice_search04 "&CONCATENATE(G213,":"&D214)&" check")

&""&CHAR(10)&""&IF(ISBLANK(H214),"","server ioffice_search05 "&CONCATENATE(H213,":"&D214)&" check")

&""&CHAR(10)&""&IF(ISBLANK(I214),"","server ioffice_search06 "&CONCATENATE(I213,":"&D214)&" check")

&""&CHAR(10)&""&IF(ISBLANK(J214),"","server ioffice_search07 "&CONCATENATE(J213,":"&D214)&" check")

&""&CHAR(10)&""&IF(ISBLANK(K214),"","server ioffice_search08 "&CONCATENATE(K213,":"&D214)&" check")


=IF(ISBLANK(D215),"","server ioffice_inst_search01 "&CONCATENATE(D213,":"&D215)&" check")

&""&CHAR(10)&""&IF(ISBLANK(E215),"","server ioffice_inst_search02 "&CONCATENATE(E213,":"&D215)&" check")

&""&CHAR(10)&""&IF(ISBLANK(F215),"","server ioffice_inst_search03 "&CONCATENATE(F213,":"&D215)&" check")

&""&CHAR(10)&""&IF(ISBLANK(G215),"","server ioffice_inst_search04 "&CONCATENATE(G213,":"&D215)&" check")

&""&CHAR(10)&""&IF(ISBLANK(H215),"","server ioffice_inst_search05 "&CONCATENATE(H213,":"&D215)&" check")

&""&CHAR(10)&""&IF(ISBLANK(I215),"","server ioffice_inst_search06 "&CONCATENATE(I213,":"&D215)&" check")

&""&CHAR(10)&""&IF(ISBLANK(J215),"","server ioffice_inst_search07 "&CONCATENATE(J213,":"&D215)&" check")

&""&CHAR(10)&""&IF(ISBLANK(K215),"","server ioffice_inst_search08 "&CONCATENATE(K213,":"&D215)&" check")