Excel 2007 - 如何寫入以下Formula

💻 軟件台程式編寫及設計

[匿名]

2013-07-03 7:13 am

如果想寫入以下Formula，應如何輸入:

當A1是N/A 則顯示N/A
當A1>C1則顯示大
當A1<C1則顯示小
當A1=C1則顯示中

Thank you

更新1:

謝謝你。我之前輸入了: =IF(A4=N/A,"N/A",IF(A4>C4,"大",IF(A4

回答 (1)

Lulu

2013-07-03 5:12 pm

✔ 最佳答案

如果個N/A 是error message 的話 (即 #N/A):
=IF(ISERROR(A1),"N/A",IF(A1>C1,"大",IF(A1<C1,"小",IF(A1=C1,"中")

如果個N/A 是文字的話 :
=IF(A4="N/A","N/A",IF(A4>C4,"大",IF(A4<C4,"小",IF(A4=C4,"中"))))

👍 0 👎 0

收錄日期: 2021-04-20 14:00:02
原文連結 [永久失效]:
https://hk.answers.yahoo.com/question/index?qid=20130702000051KK00168

檢視 Wayback Machine 備份