Excel 0928
This presentation is the property of its rightful owner.
Sponsored Links
1 / 4

Excel 0928 PowerPoint PPT Presentation


  • 63 Views
  • Uploaded on
  • Presentation posted in: General

Excel 0928. 蔡進義 Chin-Yi Tsai (Matt) [email protected] =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 )

Download Presentation

Excel 0928

An Image/Link below is provided (as is) to download presentation

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

Excel 0928

蔡進義

Chin-Yi Tsai (Matt)

[email protected]


Function

=SUM(C2:G2)

=Average(C45:C51)

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

Function


Function cont d

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),"不合格","合格")


Function cont d1

Function (Cont’d)

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

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


  • Login