slide1 n.
Download
Skip this Video
Loading SlideShow in 5 Seconds..
Index 函数 PowerPoint Presentation
Download Presentation
Index 函数

Loading in 2 Seconds...

play fullscreen
1 / 1

Index 函数 - PowerPoint PPT Presentation


  • 409 Views
  • Uploaded on

Index 函数. Index : 函数 INDEX() 有两种形式:数组和引用。数组形式通常返回数值或数值数组;引用形式通常返回引用。 INDEX(array , row_num , column_num) 返回数组中指定的单元格或单元格数组的数值。

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

Index 函数


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
slide1

Index函数

  • Index:函数INDEX()有两种形式:数组和引用。数组形式通常返回数值或数值数组;引用形式通常返回引用。INDEX(array,row_num,column_num)返回数组中指定的单元格或单元格数组的数值。
  • 语法:INDEX(reference,row_num,column_num,area_num)返回引用中指定单元格或单元格区域的引用。如果省略area_num,则INDEX函数使用区域1 。实例:如果A1=68、A2=96、A3=90,则公式“=INDEX(A1:A3,1,1)”返回68,=INDEX(A1:A3,1,1,1)返回68。 如果 INDEX 的第一个参数是数组常量,请使用数组形式。 如果将 row_num 或 column_num 设置为 0(零),INDEX 将分别返回整列或整行的值。
  • 实际工作中格式是: INDEX(reference,row_num,0)-备注