i want to know why it is wrong.
=IF(AC2="VALUE!","",AC2)
Tks
EXCEL FORMULA
2007-07-25 7:05 pm
回答 (2)
2007-07-26 5:28 am
✔ 最佳答案
" VALUE! " ---- > 相信這是運算之後的錯誤值e.g. ABC x 1 = #VALUE!
試試修改公式如下:
=IF(ISERROR( AC2 ), " " ,AC2)
OR
=IF(ISERR(AC2), " ",AC2)
(註: 公式中沒有空格)
2007-07-26 1:28 am
no problem of the excel formula
=IF(AC2="VALUE!","",AC2)
but what do u want to do?
=IF(AC2="VALUE!","",AC2)
but what do u want to do?
收錄日期: 2021-04-27 13:24:00
原文連結 [永久失效]:
https://hk.answers.yahoo.com/question/index?qid=20070725000051KK01164