Excel编写代码如if或者insert

=CONCATENATE("if"," ("," no=="""&B166&"""",")"," return """&A166&"""",";")

CONCATENATE函数里面是可以写多个字符串的

=CONCATENATE("INSERT INTO table (column1, column2, column3) VALUES ('",A248,"', '",B248,"', '",D248,"', '",J248,"', '",K248,"', '",L248,"');")
=CONCATENATE("INSERT INTO table (column1, column2, column3) VALUES ('",A4,"', '",B4,"', '",D4,"', '",J4,"', '",K4,"', '",L4,"');")