4D v18
FINDCELL
- 4D View Pro Handbuch
-
- Formeln in 4D View Pro
-
- Operatoren und Werte
- Zellenreferenzen
- Formeln vom Plug-In 4D View konvertieren
- ABS
- ACOS
- AND
- ASIN
- ATAN
- AVERAGE
- COLUMNLETTER
- COS
- COUNTA
- EXP
- FALSE
- FINDCELL
- FV
- IF
- INDIRECT
- ISBLANK
- LEN
- LN
- LOOKUP
- MAX
- MID
- MIN
- NOT
- NOW
- NPER
- OR
- PI
- PMT
- PV
- RAND
- RATE
- ROUND
- ROW
- RUNTIME_CURRENT_TIME
- RUNTIME_DATE
- RUNTIME_STRING
- RUNTIME_TIME
- RUNTIME_VIEW_STRING
- SIN
- SQRT
- STDEV.P
- SUBSTITUTE
- SUM
- TAN
- TEXT
- TODAY
- TRUE
- TYPE
- VAR.P
4D v18
FINDCELL
FINDCELL
| FINDCELL ( toFind , searchRange ) | ||||||||
| Parameter | Typ | Beschreibung | ||||||
| toFind | CellRef |
|
Value to find | |||||
| searchRange | CellRef |
|
Cells to search | |||||
The FINDCELL function searches for the toFind value in the searchRange range of cells and returns the reference of the cell in which it was found. This reference cannot be displayed, but can be used by other 4D View Pro functions that accept a cell reference (CellRef) as parameter.
toFind must contain the reference of a cell that actually contains the value to find.
Assuming cell C3 contains 10:
FINDCELL(C3,A1:B9) //returns 10 if the value is actually found in the A1:B9 cell range, otherwise it returns an error.
Siehe auch
EIGENSCHAFTEN
Produkt: 4D
Thema: Formeln in 4D View Pro
GESCHICHTE
ARTIKELVERWENDUNG
4D View Pro Handbuch ( 4D v18)
© 1985-2020 4D SAS / 4D, Inc. Alle Rechte vorbehalten.