UC知道excel中，IF函数使用&连接，在一个单元格中，可以使用多少次数？
来源：百度知道 编辑：UC知道 时间：2024/05/31 10:27:29
好像可以用6次？如何突破呢？
=IF(R4="","New Order Confirming / ","")&IF(AA4="-","",IF(AB4="","Sky Sample Preparing / ",IF(AND(AB4<>"",AD4=""),"Sky Designing / ",IF(AND(AD4<>"",AJ4=""),"Package Waiting / ",""))))&IF(AC4="-","",IF(AD4="","Supplier Artwork Preparing / ",""))&IF(AK4="-","",IF(Q4-TODAY()>25,"",IF(AND(AM4="",Q4-TODAY()<=25),"Booking Reminding / ",IF(AND(AM4<>"",AN4=""),"Inspection Result Waiting / ",IF(AND(AN4="pass",AT4=""),"Release Waiting / ","")))))&IF(AK4="-","",IF(Q4-TODAY()>25,"",IF(AN4="","",IF(AN4="Pass","",IF(AND(AN4="fail",AO4="
=IF(R4="","New Order Confirming / ","")&IF(AA4="-","",IF(AB4="","Sky Sample Preparing / ",IF(AND(AB4<>"",AD4=""),"Sky Designing / ",IF(AND(AD4<>"",AJ4=""),"Package Waiting / ",""))))&IF(AC4="-","",IF(AD4="","Supplier Artwork Preparing / ",""))&IF(AK4="-","",IF(Q4-TODAY()>25,"",IF(AND(AM4="",Q4-TODAY()<=25),"Booking Reminding / ",IF(AND(AM4<>"",AN4=""),"Inspection Result Waiting / ",IF(AND(AN4="pass",AT4=""),"Release Waiting / ","")))))&IF(AK4="-","",IF(Q4-TODAY()>25,"",IF(AN4="","",IF(AN4="Pass","",IF(AND(AN4="fail",AO4="
IF函数连接没有次数限制，IF函数嵌套有次数限制。
IF函数也可用数组，如：
=If(A={条件1,条件2,条件3,条件4,条件5,...},{结果1,结果2,结果3,结果4,结果5,...},)
======================================
继续加“&If(,,)”没有问题
=======================================
我是XP,是行的。难道是小Bug，那恭喜你.