1 / 1

Index 函数

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

jadon
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. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. 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）-备注

More Related