[問題] VBA判斷儲存格中值的大小
(若是和其他不同軟體互動之問題 請記得一併填寫)
軟體:Excel
版本:2013
請教各位專家高手，這裡遇到的狀況是某資料區範圍A1:B100 (100 rows、2 columns)
當中每個儲存格是先用工作表函數Average在他處求得的平均值，之後用VBA分別比較
每一列A欄跟B欄的值的大小，但卻出現大部分結果判斷正確，只有某幾列會把A、B兩欄
相等的值判斷成"smaller"或"bigger"，VBA判斷式如下，再請教各位了，謝謝。
For i = 1 to 100
If Cells(i, 1) > Cells(i, 2) Then
Cells(i, 3) = "bigger"
ElseIf Cells(i, 1) < Cells(i, 2) Then
Cells(i, 3) = "smaller"
Else
Cells(i, 3) = "--"
End If
--
※ 發信站: 批踢踢實業坊(ptt.cc), 來自: 123.193.194.224
※ 文章網址: https://www.ptt.cc/bbs/Office/M.1488426953.A.297.html
→
03/02 12:13, , 1F
03/02 12:13, 1F
推
03/02 12:59, , 2F
03/02 12:59, 2F
→
03/02 14:41, , 3F
03/02 14:41, 3F
→
03/02 14:41, , 4F
03/02 14:41, 4F
→
03/02 14:58, , 5F
03/02 14:58, 5F
→
03/02 15:13, , 6F
03/02 15:13, 6F
→
03/02 15:14, , 7F
03/02 15:14, 7F
→
03/02 15:30, , 8F
03/02 15:30, 8F
→
03/02 16:08, , 9F
03/02 16:08, 9F
→
03/02 16:49, , 10F
03/02 16:49, 10F
→
03/02 16:49, , 11F
03/02 16:49, 11F
→
03/02 16:49, , 12F
03/02 16:49, 12F
→
03/02 16:59, , 13F
03/02 16:59, 13F
→
03/02 17:00, , 14F
03/02 17:00, 14F
→
03/02 17:03, , 15F
03/02 17:03, 15F
→
03/02 17:05, , 16F
03/02 17:05, 16F
→
03/02 17:05, , 17F
03/02 17:05, 17F
→
03/02 17:19, , 18F
03/02 17:19, 18F
→
03/02 17:57, , 19F
03/02 17:57, 19F
→
03/02 17:57, , 20F
03/02 17:57, 20F
→
03/02 22:13, , 21F
03/02 22:13, 21F
Office 近期熱門文章
PTT數位生活區 即時熱門文章
