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
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