就是在电子表格中,将日期生成以下的单号,将在大写金额前加人民币_百...答:G2单元格写入公式 =TEXT(G3,"!N!O:emmdd")&TEXT(ROW(A18)/18,"000")或 ="NO:"&TEXT(G3,"emmdd")&TEXT(ROW(A18)/18,"000")再复制G2单元格粘帖到G20,G38...单元格 =IF(F17=0,"","人民币:"&SUBSTITUTE(SUBSTITUTE(TEXT(TRUNC(FIXED(F17)),"[dbnum2]G/通用格式元;负[dbnum...
EXCEL假值预设如为“圆通”,当输入快递单号如6开口或者3,4,8,预选...答:B2=IF(A2="","",IF(C2="","圆通",VLOOKUP(--LEFT(C2),{3,"申通";4,"中通";6,"德邦";8,"圆通"},2,)&"快递"))或=IF(A2="","",IF(C2="","圆通",LOOKUP(,0/(--LEFT(C2)={3,4,6,8}),{"申通","中通","德邦","圆通"}&"快递")))或=IF(A2="","",IF(C2="...