{:1_180:}{:1_180:}{:1_180:}
{:1_89:}
:)
{:1_180:}{:1_180:}
{:1_180:}{:1_180:}
谢谢
{:1_180:}{:1_180:}{:1_180:}
allene 发表于 2024-5-30 21:13
谢谢分享,怎样把3位小数改为2位?
=IF(OR($N$3="",$R$2="",$R$3=""),"",ROUND((AVERAGE($R$2,$R$3)-($R$2-$R$3)*0.17)+($R$2-$R$3)*0.36*RAND(),2))
加ROUND
{:1_180:}
感谢分享