Excel2003 xlfn.iferror

Question

请问大侠这个公式如何修改才能在Excel2003下使用呢
_xlfn.IFERROR(IF(TodayT-WorkT-FirstT<=0,,IF(SUM(B6:$U6)=0,MIN($O6*(TodayT-WorkT-FirstT),$Q6-SUM(B6:$U6)),MIN($O6*(TodayT-WorkT),$Q6-SUM(B6:$U6)))),0))))
谢谢。。。。。

Answer 1

iferror函数翻译过来就是if(iserror(公式),1,0),你懂的。
so,
=IF(ISERROR(IF(TodayT-WorkT-FirstT<=0,,IF(SUM(B6:$U6)=0,MIN($O6*(TodayT-WorkT-FirstT),$Q6-SUM(B6:$U6)),MIN($O6*(TodayT-WorkT),$Q6-SUM(B6:$U6))))
),0)