Bilgi Fonksiyonları

Top  Previous  Next

ame

Description

Syntax

CELL 




Returns information about the formatting, location, or contents of a cell.

CELL(info_type, [reference])

ERROR.TYPE 




Returns a number corresponding to one of error values or returns #N/A if no error exists.

ERROR.TYPE(value)

INFO 




Returns information about the current operating environment.

INFO(type_text)

ISBLANK 




Checks whether a value refers to an empty cell.

ISBLANK(value)

ISERR 




Checks whether a value or expression returns an error except #N/A.

ISERR(value)

ISERROR 




Checks whether a value or expression returns any error value (#N/A, #VALUE!, #REF!, #DIV/0!, #NUM!, #NAME?, or #NULL!).

ISERROR(value)

ISEVEN 




Checks whether the number is even.

ISEVEN(value)

ISFORMULA 




Checks whether the referenced cell contains formula.

ISFORMULA(reference)

ISLOGICAL 




Checks whether a value is a logical value.

ISLOGICAL(value)

ISNA 




Checks whether a value or expression returns the #N/A error.

ISNA(value)

ISNONTEXT 




Checks whether a value or expression is not text.

ISNONTEXT(value)

ISNUMBER 




Checks whether a value or expression is a number.

ISNUMBER(value)

ISODD 




Checks whether the number is odd.

ISODD(value)

ISREF 




Checks whether a value is a reference.

ISREF(value)

ISTEXT 




Checks whether a value or expression is text.

ISTEXT(value)

N 




Returns a value converted to a number.

N(value)

NA 




Returns the error value #N/A.

NA()

SHEET 




Returns the sheet number of the referenced sheet.

SHEET(value)

The value parameter is optional. It is the name of a sheet or a reference for which to obtain the sheet number. If the value is omitted, the number of the sheet that contains the function is returned.

SHEETS 




Returns the number of sheets in a reference.

SHEETS(reference)

The reference parameter is optional. If the parameter is omitted, the number of sheets in the workbook that contains the function is returned.

TYPE 




Returns the type of value.

TYPE(value)