<p>我这边同事给我了一个好用的公式,跟大家分享,MAX(((A1-1600-25*{0,0,1,5,15,55,135,255,415,615})/(1-5%*{0,1,2,3,4,5,6,7,8,9}))*5%*{0,1,2,3,4,5,6,7,8,9}-25*{0,0,1,5,15,55,135,255,415,615}+A1,0)<table cellspacing="0" cellpadding="0" width="72" border="0" style="WIDTH: 54pt; BORDER-COLLAPSE: collapse;"><colgroup><col width="72" style="WIDTH: 54pt;"></col></colgroup><tbody><tr height="21" style="HEIGHT: 15.75pt;"><td class="xl22" width="72" height="21" style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; WIDTH: 54pt; BORDER-BOTTOM: #d4d0c8; HEIGHT: 15.75pt; BACKGROUND-COLOR: transparent;"><font face="Times New Roman"></font></td></tr></tbody></table></p> |