是0.25-0.75之间接近0.5取0.5,大于等于0.75接近1取舍为整数;请高手赐函数.
=MROUND(A1,0.5)
没有MROUND函数
=LOOKUP(A1-IF(ISERR(LEFT(A1,FIND(".",A1)-1)),0,--LEFT(A1,FIND(".",A1)-1)),{0,0.25,0.75},{0,0.5,1})这公式有错,明天写给你,下班了B1=lookup(A1-INT(A1),{0,0.25,0.75},{0,0.5,1}+INT(A1)) 下拉