计算金额 按2种不同标准 (10605)


G2=LOOKUP(TEXT(E2-D2,"YM")*1,{0,24},IF({1,0},TEXT(E2-D2,"YM")*H$2,I$2*12))*C2


另解=MIN(TEXT(E2-D2,"YM")*H$2,I$2*12)*C2


留言