Excel表中保留数值有效位数且四舍六入五单双的方法

直接上公式吧。
第一行保留5位 ，第二行，保留4位，第三行保留3位。
FIXED(FIXED(A1,4-RIGHT(TEXT(A1,"0.00E+00"),3),1)-(MOD(A110^(5-RIGHT(TEXT(A1,"0.00E+00"),3)),20)=5)10^(RIGHT(TEXT(A1,"0.00E+00"),3)-4),4-RIGHT(TEXT(A1,"0.00E+00"),3),1)

FIXED(FIXED(A1,3-RIGHT(TEXT(A1,"0.00E+00"),3),1)-(MOD(A110^(4-RIGHT(TEXT(A1,"0.00E+00"),3)),20)=5)10^(RIGHT(TEXT(A1,"0.00E+00"),3)-3),3-RIGHT(TEXT(A1,"0.00E+00"),3),1)

FIXED(FIXED(A1,2-RIGHT(TEXT(A1,"0.00E+00"),3),1)-(MOD(A110^(3-RIGHT(TEXT(A1,"0.00E+00"),3)),20)=5)10^(RIGHT(TEXT(A1,"0.00E+00"),3)-2),2-RIGHT(TEXT(A1,"0.00E+00"),3),1)

A1是需要修约的数值单元格，
保留位数如下图标识：

image.png image.png