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