FINDCELL

Vous êtes sur le site Web historique de la documentation de 4D. Les documentations sont progressivement déplacées vers developer.4d.com

Accueil

4D View Pro
- Formules 4D View Pro
- - Opérateurs et valeurs
  - Références des cellules
  - Conversion des formules du plug-in 4D View
  - 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

Accueil

4D v19

4D View Pro

Formules 4D View Pro

FINDCELL


FINDCELL ( toFind , searchRange )

Paramètre	Type	Description
toFind	RefCell	Value to find
searchRange	RefCell	Cells to search

Description

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.