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
TRUE if the cell is empty.
=ISBLANK(value)TRUE if the value is any error.
=ISERROR(value)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)
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