判斷兩個正數x1和x2是否相等,精確到2位小數,可以這樣:
y:IF( round(x1*100+0.5)=round(x2*100+0.5), y1,y2);
我對通達信的round(x)函數曾有質疑,不知現狀如何。如果想避開它,可以寫:
y:IF( intpart(x1*100+0.5)=intpart(x2*100+0.5), y1,y2);