所需公式可参考图示:
C3=DATEDIF(B3,DATE(YEAR(TODAY()),MONTH(TODAY()),10),"M")/12
D3=IF(C3<2,0,MIN(200+INT(C3-2)*80,1000))
E3=IF(DATEDIF(B3,DATE(YEAR(TODAY()),MONTH(TODAY()),10),"M")/12<2,0,MIN(200+INT(DATEDIF(B3,DATE(YEAR(TODAY()),MONTH(TODAY()),10),"M")/12-2)*80,1000))
本回答被提问者采纳