FINDCELL

Dies ist die alte 4D Dokumentations-Website. Die neue und aktualisierte Dokumentation finden Sie unter developer.4d.com

Home

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

Home

4D v19

4D View Pro Handbuch

Formeln in 4D View Pro

FINDCELL


FINDCELL ( toFind , searchRange )

Parameter	Typ	Beschreibung
toFind	CellRef	Value to find
searchRange	CellRef	Cells to search

Beschreibung

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.