當前位置:星座運勢大全官網 - 星座查詢 - Excel表格星座計算公式(輸入生日計算星座)

Excel表格星座計算公式(輸入生日計算星座)

{"1/21 "," 2/20 "," 3/21 "," 4/21 "," 5/22 "," 6/22 "," 7/23 ","牧羊人","金牛座","雙子座","巨蟹","獅子","處女","天秤座","天蠍座","射手座","摩羯座" } &;"座位”)。

例如,下面的公式

=IF(ISNA(VLOOKUP(B5,sheet1!$B$2:$E$179,2,FALSE)),"",VLOOKUP(B5,sheet1!$B$2:$E$179,2,FALSE))

X=VLOOKUP(B5,sheet1!$B$2:$E$179,2,FALSE) ->如果找到相同的條件,取其值。整個事情就是找值,就是找不到。用空白代替NA。公式ISNA類似於ISERROR,但是當ISERROR出錯時,也會顯示空白。對於ISNA,將顯示錯誤,NA將顯示空白。

A1參考樣式

默認情況下,Excel使用A1引用樣式,引用字母標識列(從A到IV,*** 256列,註意:不同版本最大列數不同),引用數字標識行(從1到65536)。這些字母和數字被稱為行號和列標簽。若要引用單元格,請輸入列標簽和行號。例如,B2引用位於b列和2行交叉處的單元格。