如图:
根据你的补充问题修改了一下:
=VLOOKUP(INT(((YEAR(NOW())-YEAR(B2))*12+(MONTH(NOW())-MONTH(B2))+SIGN(DAY(NOW())-DAY(B2)))/12),{0,50;1,100;5,150;10,200;15,250;20,300;25,350;30,400;35,450},2)
如图:
根据你的补充问题修改了一下:
=VLOOKUP(INT(((YEAR(NOW())-YEAR(B2))*12+(MONTH(NOW())-MONTH(B2))+SIGN(DAY(NOW())-DAY(B2)))/12),{0,50;1,100;5,150;10,200;15,250;20,300;25,350;30,400;35,450},2)