Yahoo奇摩 網頁搜尋

  1. 請建立下列公式 B51=INDIRECT("R"& CHOOSE (MOD(ROW(),3)+1,2,25,48)&"C"&INT...

  2. 方法很多 以下應為最好理解之作法 若勾選值在A1 則B1= CHOOSE (A1,-1,-1,-1,-1,-1,0,0,0,1,1)

  3. 在H31插入 函數 IF。 logical test填上: H29="A" value is true...

  4. 假設輸入值在A1 B1 = CHOOSE (A1,"生活小物","戶外生活用品","衛浴用品","...

  5. 方法一:不比對 表2 的資料,直接傳回固定值:甲....至己等 B1= choose (A1,"甲","乙","丙","丁","戊"...

  6. ...,{0,70,80,90;"丁","丙","乙","甲"}) = CHOOSE (A1/10-5,"丁","丙","乙","甲") =MID...

  7. ...40:38 補充: 筆者上面所回答者,公式尚可改為: =LOOKUP(9E+307, CHOOSE ({1,2},"",LOOKUP(9E+307,A:A))) 上述公式僅...

  8. B1=--TEXT(--(2&$A1), CHOOSE (COLUMN(A1),"yy","mm"...(TEXT(--(2&$A1), CHOOSE (COLUMN(A1),"yyy","mm...

  9. ... As Integer) As String WhatDay = Choose (Indx, "Sunday", "Monday", "Tuesday...

  10. ...45,90})) 如不會超過100%,則B1: =IF(A1<70%,5, CHOOSE (A1*10-6,10,30,45,90)) 2012-06-21 03:04:10 補充: 如資料輸入於A1...