202205151604支票每張最多金額 (9958)

G2:G12{=IFERROR(RIGHT(SMALL(IF(B$2:B$5-(COLUMN(A:I)-1)*$C$2>0,SUBSTITUTE(TEXT(B$2:B$5-(COLUMN(A:I)-1)*$C$2,"[>"&$C$2&"]"&SUBSTITUTE($C$2,0,"~")&";[>]0;~"),"~",0)+ROW($1:$4)*10^8+COLUMN(A:I)*10^7),ROW(A1)),7)*1,"")

H2:O5=TEXT(MIN($B2-(COLUMN(A1)-1)*$C$2,$C$2),"0;;")

沒有上一則|日誌首頁|沒有下一則
回應
關鍵字
    沒有新回應!
    blank