1 / 4

# Excel 0928 - PowerPoint PPT Presentation

Excel 0928. 蔡進義 Chin-Yi Tsai (Matt) cyt@pmlab.iecs.fcu.edu.tw. =SUM(C2:G2). =Average(C45:C51). =(C2*0.25)+(D2*0.15)+((E2+F2+G2)/3)*0.6. Function. Countif( C1:C10 , “>60” ) Countif( C1:C10 , “<60” ). Function (Cont’d). IF ( logical_test , value_if_true , value_if_false )

I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.

## PowerPoint Slideshow about ' Excel 0928' - griffin-mayer

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.

- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript

### Excel 0928

Chin-Yi Tsai (Matt)

cyt@pmlab.iecs.fcu.edu.tw

=Average(C45:C51)

=(C2*0.25)+(D2*0.15)+((E2+F2+G2)/3)*0.6

Function

Countif(C1:C10, “>60” )

Countif(C1:C10, “<60” )

Function (Cont’d)

IF( logical_test , value_if_true , value_if_false )

IF(E2>60, “合格”, “不合格”)

=IF(OR(OR(C2=0,D2=0,E2=0,F2=0,G2=0),H2<60),"不合格","合格")

• 要建立一個小型的自動成績查詢, 我們會用到 VLOOKUP這個函數來進行查詢, 以下就先說明這個函數的用法

• VLOOKUP函數的功用,就是在清單中的第一欄尋找特定值, 找到時,就會傳回所找到的那一列中某個欄位的值