=IF(‘Added Safe&Account‘!N285="",‘Added Safe&Account‘!N285,"")

2.等同于IF,ELSE IF,ELSE的语法。AND(值1，值2，值3)用来表示且。
如果同时满足两个条件则为22，否则如果同时满足另两个条件则为1521，如果都不符合则为空值
e.g.1
=IF(C3="OS","Operating System", IF(C3="NW","Network Device",IF(C3="DB","Database",IF(C3="App","Operating System"))))
e.g.2
=IF(AND(‘Added Safe&Account‘!E285="AIX",‘Added Safe&Account‘!H285="default"),"22",IF(AND(‘Added Safe&Account‘!E285="Unix_or_Linux",‘Added Safe&Account‘!H285="default"),"22",IF(AND(‘Added Safe&Account‘!C285="NW",‘Added Safe&Account‘!G285="Telnet"),"23",IF(‘Added Safe&Account‘!E285="SQL_Server","1433",IF(‘Added Safe&Account‘!E285="Oracle","1521","")))))

3.IF的判断语句,输出结果如果要用hyphen连接,则使用&连接。
OR(值1，值2，值3)用来表示或。
=IF(OR(‘Added Safe&Account‘!C285="NW",‘Added Safe&Account‘!C285="OS",‘Added Safe&Account‘!C285="App"),‘Added Safe&Account‘!W285&"-"&‘Added Safe&Account‘!U285&"-"&‘Added Safe&Account‘!K285&"-"&‘Added Safe&Account‘!M285,‘Added Safe&Account‘!W285&"-"&‘Added Safe&Account‘!U285&"-"&‘Added Safe&Account‘!K285&"-"&‘Added Safe&Account‘!M285&"-"&‘Added Safe&Account‘!H285)

4.以某字符为分隔符，来截取字符串字段
参考文档：http://www.voidcn.com/article/p-okydhuiw-cv.html

Q29=http://www.163.com/sports/Arsenal.html
=TRIM(LEFT(SUBSTITUTE(Q29,":",REPT(" ",LEN(Q29))),LEN(Q29)))
值为http

WINServerLocal
=TRIM(LEFT(SUBSTITUTE(‘Added Safe&Account‘!U285,"_",REPT(" ",LEN(‘Added Safe&Account‘!U285))),LEN(‘Added Safe&Account‘!U285)))

以上已更新

无标题文章

原文：https://blog.51cto.com/7350550/2414280