penum()

Read(203) Label: judge, enum group,

Here’s how to use penum() function.

E.penum()

Description:

Judge to which enum group an object belongs.

Syntax:

E.penum(y)

Note:

The functions judges to which group of record sequence E the y belongs, and returns the sequence number(s) of the group(s), i.e. sequence number(s) of the record(s) of E that satisfy the grouping condition.

Parameters:

E

A sequence/record sequence

y

y is allowed to be omitted

Options:

@r

Return the sequence numbers of all the groups satisfying the grouping condition, and the default is to return the sequence number of the first group

@n

If no eligible sequence member of E is found, return the length of E plus 1.

Function keyword:

?

Represents the value of y

Return value:

A sequence number or an integer sequence composed of sequence numbers

Example:

Ø  E is the sequence

 

A

 

1

=["?<=70&&?<=60","?>=70 && ?<=90","?>=90"]

Use y to replace the ? in the grouping conditions when computing

2

=A1.penum(90)

2; the sequence number of the first group satisfying the condition will be returned

3

=A1.penum@r(90)

[2,3]; return the sequence numbers of all the groups

4

=A1.penum@n(43)

4

Related functions:

P.enum()