202205161405租金何月付 (9960)

G2:S5{=IF(OR(G$1-EOMONTH($B2,(ROW($1:$12)-1)*FIND(LEFT($E2),"月-季--半-----年")-1)-1=0)*(EOMONTH($C2,-1)+1-G$1>0),$F2,"")

無年付 租金為總租金=IF(COUNT(0/(SUM($F2:F2)<$F2*2)/(MOD(DATEDIF($B2-DAY($B2),G$1,"m"),FIND(LEFT($E2),"月-季--半"))=0)),$F2/$D2*FIND(LEFT($E2),"月-季--半"),"")

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