Excel只保留小数点后面3位数
问题描述:
Excel只保留小数点后面3位数
如何让下面公式计算后只保留小数点后面3位数,
=IF(B1="","",(M1-N1)/N1
答
=IF(B1="","",ROUND((M1-N1)/N1,3))
Excel只保留小数点后面3位数
如何让下面公式计算后只保留小数点后面3位数,
=IF(B1="","",(M1-N1)/N1
=IF(B1="","",ROUND((M1-N1)/N1,3))