Skip to content

Excel functions · 22 functions

Excel information and web functions

Functions that test whether a cell is blank, a number, text or an error and report error types and cell details, plus the web functions that encode text for URLs.

Functions explained in full

All functions

  • ISBLANKEBOŞSAFull page

    TRUE if the cell is empty.

    =ISBLANK(value)
  • ISERROREHATALIYSAFull page

    TRUE if the value is any error.

    =ISERROR(value)
  • ISNUMBERESAYIYSAFull page

    TRUE if the value is a number.

    =ISNUMBER(value)
  • CELLHÜCRE

    Information about a cell.

    =CELL(info_type, [reference])
  • ERROR.TYPEHATA.TİPİ

    Number of an error value.

    =ERROR.TYPE(error_val)
  • INFOBİLGİ

    Information about the operating environment.

    =INFO(type_text)
  • ISERREHATA

    TRUE if the value is an error other than #N/A.

    =ISERR(value)
  • ISEVENÇİFTMİ

    TRUE if the number is even.

    =ISEVEN(number)
  • ISFORMULAEFORMÜLSE

    TRUE if the referenced cell contains a formula.

    =ISFORMULA(reference)
  • ISLOGICALEMANTIKSALSA

    TRUE if the value is logical.

    =ISLOGICAL(value)
  • ISNAEYOKSA

    TRUE if the value is #N/A.

    =ISNA(value)
  • ISNONTEXTEMETİNDEĞİLSE

    TRUE if the value is not text.

    =ISNONTEXT(value)
  • ISODDTEKMİ

    TRUE if the number is odd.

    =ISODD(number)
  • ISREFEREFSE

    TRUE if the value is a reference.

    =ISREF(value)
  • ISTEXTEMETİNSE

    TRUE if the value is text.

    =ISTEXT(value)
  • NS

    Converts a value to a number (text becomes 0).

    =N(value)
  • NAYOKSAY

    Returns the #N/A error.

    =NA()
  • SHEETSAYFA

    Sheet number.

    =SHEET([value])
  • SHEETSSAYFALAR

    Number of sheets.

    =SHEETS([reference])
  • TYPETÜR

    Type of a value.

    =TYPE(value)

Web functions

  • ENCODEURLURLKODLA

    URL-encodes text.

    =ENCODEURL(text)
  • FILTERXMLXMLFİLTRELE

    Extracts value(s) from XML text with an XPath expression.

    =FILTERXML(xml, xpath)

Excel functions →

Stop memorising formulas. Describe them.

Bring your table into the tool and say what you need; Nexell builds the formula and shows it in a preview.

Try it free