Tools
AI tool

Formula Explainer

Paste a formula. See each function, the cells it reads, and where it works.

Live AI adds a plain-language walkthrough at launch.

3 functions, read from the outside in

FunctionWhat it doesWorks in
IFERRORValue on error, otherwise formula resultExcel Sheets
XLOOKUPSearches range, returns matchExcel Sheets
TEXTSPLITSplits text by delimitersExcel

Cells used: F2, A2:A50, C2

TEXTSPLIT works only in Excel. Closest option: SPLIT.