Here’s how to use penum() function.
Description:
Judge to which enum group an object belongs.
Syntax:
E.penum(y)
Note:
The functions judges to which group of sequence/record sequence E member 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.
Parameter:
|
E |
A sequence/record sequence |
|
y |
A member; allowed to be omitted |
Option:
|
@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:
Sequence/Integer sequence
Example:
Ø E is the sequence
|
|
A |
|
|
1 |
=["?<=70&&?>=60","?>=70 && ?<=90","?>=90"] |
Use y to replace ? 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 function: