回覆列表
  • 1 # 使用者3977671246998

    D69公式:(數字之間用逗號,間隔。)

    =IF(COUNT(H69,H71,H73,H74,H76,H78),IFERROR(H69&",","")&IFERROR(H71&",","")&IFERROR(H73&",","")&IFERROR(H74&",","")&IFERROR(H76&",","")&IFERROR(H78&",",""),"無")

    如果不需要使用逗號間隔的,公式短些:

    =IF(COUNT(H69,H71,H73,H74,H76,H78),IFERROR(H69,"")&IFERROR(H71,"")&IFERROR(H73,"")&IFERROR(H74,"")&IFERROR(H76,"")&IFERROR(H78,""),"無")

    https://iknow-pic.cdn.bcebos.com/32fa828ba61ea8d3201b88e89b0a304e251f5825

  • 中秋節和大豐收的關聯?
  • 孩子四歲學街舞會影響將來的身高嗎?