裝卦Excel檔
功能有些陽春
再幾天有時間
再做一個複雜些的^^

補充一下<br />檔案中多數位置都已保護<br />到干支年 月 日處選擇<br />再到卦中每一爻處選擇陰陽<br /><br />最後 有錯誤煩請告知

=IF(B6="青龍","朱雀",IF(B6="朱雀","勾陳",IF(B6="勾陳","螣蛇",IF(B6="螣蛇","白虎",IF(B6="白虎","玄武",IF(B6="玄武","青龍","X"))))))<br /><br />=IF(B7="青龍","朱雀",IF(B7="朱雀","勾陳",IF(B7="勾陳","螣蛇",IF(B7="螣蛇","白虎",IF(B7="白虎","玄武",IF(B7="玄武","青龍","X"))))))<br /><br />=IF(B8="青龍","朱雀",IF(B8="朱雀","勾陳",IF(B8="勾陳","螣蛇",IF(B8="螣蛇","白虎",IF(B8="白虎","玄武",IF(B8="玄武","青龍","X"))))))<br /><br />=IF(B9="青龍","朱雀",IF(B9="朱雀","勾陳",IF(B9="勾陳","螣蛇",IF(B9="螣蛇","白虎",IF(B9="白虎","玄武",IF(B9="玄武","青龍","X"))))))<br /><br />=IF(B10="青龍","朱雀",IF(B10="朱雀","勾陳",IF(B10="勾陳","螣蛇",IF(B10="螣蛇","白虎",IF(B10="白虎","玄武",IF(B10="玄武","青龍","X"))))))<br /><br />=VLOOKUP(VLOOKUP(H1,base!A:T,20,FALSE),data!FH1:FI10,2,FALSE)<br />↑<br />cell B10<br /><br /><br /><br />我是過來人，提示： 這樣可減少 lookup 運算<br /><br />合併對將來運算 & 複製 會造成障礙，如：B32, 33

用 "0" 要小心，若算式中有 加減乘除，"0" 是會計錯數，這點要注意

e.g. Sheet "data"!

roll
180 甲 0
181 乙 0

謝謝