Excel单元格中编辑表达式:
CEILING(ROUND(A1,1)-0.2,0.5)
MROUND(ROUND(A1,1),0.5)
ROUND(ROUND(A1,1)*2,)/2
mysql实现:
乘以2,取出整数部分,除以2
表达式:
round(x*2,0)/2
Excel单元格中编辑表达式:
CEILING(ROUND(A1,1)-0.2,0.5)
MROUND(ROUND(A1,1),0.5)
ROUND(ROUND(A1,1)*2,)/2
mysql实现:
乘以2,取出整数部分,除以2
表达式:
round(x*2,0)/2