【導讀】2、什么是公式--------------------------------------------------------------------------------------------------------1

　　

【正文】 ............................................……...... .................. 16 IS 類函數 ..........................................................................................................................……. ...................... 17 ISEVEN..............................................................................................................................……....................... 17 ISODD....................................................................................................................................……..................... 17 N................................................................................................................................................................. 17 NA............................................................................................................................................................... 17 TYPE........................................................................................................................................................... 18 (七 )、 邏輯運算符 ................................................................................................................................ ................ 18 AND............................................................................................................................................................. 18 FALSE......................................................................................................................................................... 18 IF............................................................................................................................................................... 18 NOT.............................................................................................................................. ............................... 18 OR............................................................................................................................................................... 18 TRUE........................................................................................................................................................... 18 (八 )查找和引用函數 ........................................................................................................................................ 19 ADDRESS..................................................................................................................................................... 19 ......................................................................................................................................................... 19 ....................................................................................................................................................... 19 ....................................................................................................................................................... 19 ..................................................................................................................................................... 19 ..................................................................................................................................................... 19 ................................................................................................................................................. 19 ......................................................................................................................................................... 20 ................................................................................................................................................... 20 ..................................................................................................................................................... 20 ....................................................................................................................................................... 20 ..................................................................................................................................................... 21 ............................................................................................................................. .............................. 21 ................................................................................................................................................. ........ 21 ................................................................................................................ ........................................... 21 ............................................................................................................................................... 21 ................................................................................................................................................... 21 (九 )數學和三角函數 .................................................................................................................................. .......... 21 ............................................................................................................................................................. 21 ........................................................................................................................................................... 21 ......................................................................................................................................................... 22 ........................................................................................................................................................... 22 ................................................................