[算表] 請問if函數如何顯示在空白表格
軟體:Excel
版本:2000
A B C D E
1 12 50
我想要在E1寫一個程式,
如果A1數值大於0,則B1的數字顯示到C1的空白格,若A1小於0則會顯示D1
請問應該怎麼寫,謝謝~
我本來以為應該是:if(A1>0,B1=C1,D1)
因為我以為這樣B1的空格就會顯示和C1的一樣,
但是發現有錯誤,請問該怎麼改正?謝謝~
--
※ 發信站: 批踢踢實業坊(ptt.cc)
◆ From: 61.230.14.104
推
05/11 15:19, , 1F
05/11 15:19, 1F
→
05/11 15:46, , 2F
05/11 15:46, 2F
推
05/11 16:29, , 3F
05/11 16:29, 3F
→
05/11 16:30, , 4F
05/11 16:30, 4F
推
05/11 23:26, , 5F
05/11 23:26, 5F
→
05/12 12:31, , 6F
05/12 12:31, 6F
→
05/12 12:33, , 7F
05/12 12:33, 7F
→
05/12 12:34, , 8F
05/12 12:34, 8F
→
05/12 12:35, , 9F
05/12 12:35, 9F
→
02/06 17:00, , 10F
02/06 17:00, 10F