度友 用公式可以达到目的:
如图:
具体公式为:=IF(DATEDIF(A3,TODAY(),"Y")<1,0,IF(AND(DATEDIF(A3,TODAY(),"Y")>=1,DATEDIF(A3,TODAY(),"Y")<=3),DATEDIF(A3,TODAY(),"Y")*50,150+100*(DATEDIF(A3,TODAY(),"Y")-3)))
如有疑问可以继续交流!!!