EXCEL-循環參照問題((虛心請教))
我想在儲存格中, 輸入一個數字後(比如ENTER)後
公式計算後的結果還是顯示在原來的儲存格中
如 A1中輸入所有數字都會乘以 7 並顯示在 A1中
若使用公式會造成循環參照
請幫忙想一下吧
萬分感激
THX
EXCEL-循環參照問題((虛心請教))(10點)
2007-10-23 7:05 pm
回答 (2)
2007-10-24 12:58 am
✔ 最佳答案
可以寫一個macro來完成你的要求.在 worksheet1 寫入下列macro:
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
r = Target.Row
c = Target.Column
If r = 2 And c = 1 Then Cells(1, 1) = Cells(1, 1) * 7
End Sub
之後在A1 輸入數目, 則該格先動會顯示乘7後的值.
2007-10-23 17:07:33 補充：
可參考下面的網頁:http://www.geocities.com/shin_bingo_dog/YK-2007Oct23.xls
2007-10-23 7:42 pm
Are you sure Excel have that function? The point is, YOU must need one CELL to store the value for any calculation. If you enter at A1, and at the end have to calculation and display at the SAME cell... how Excel know the original number and the formula?
What I think is... you should input number at A1, and set formula at A2, and display on A2 cell...
Hope this help!!
What I think is... you should input number at A1, and set formula at A2, and display on A2 cell...
Hope this help!!
收錄日期: 2021-04-29 19:25:05
原文連結 [永久失效]:
https://hk.answers.yahoo.com/question/index?qid=20071023000051KK00785