EXCEL中B1 0時顯示值為a,B1=0時顯示值為b,另外C1 0時顯示值為另外一個儲存格C2的值,的函數公式。?
回答 (1)
2015-10-10 10:45 am
EXCEL中B1 0時顯示值為a,B1=0時顯示值為b
??????????????
Sub test()
If Range("B1") = 0 Then Range("B1") = "b"
If Range("C1") = 0 Then Range("C1") = Range("C2")
End Sub
??????????????
Sub test()
If Range("B1") = 0 Then Range("B1") = "b"
If Range("C1") = 0 Then Range("C1") = Range("C2")
End Sub
收錄日期: 2021-05-04 02:01:17
原文連結 [永久失效]:
https://hk.answers.yahoo.com/question/index?qid=20151010020837AAz0t74