Thursday, November 21

More Functions

Excel N Function

Excel N Function

FORMULAS, More Functions
DEFINITION:- The Excel N Function Returns A Value Converted To A Number. The N Function Can Convert True And False To 1 And 0. For A Text Value, The N Function Returns Zero. Values Are Converted According To The Table Below. Input ValueReturn ValueTRUE1FALSE0Any Number ValueReturn Same NumberAny Error Code (#VALUE, #N/A, etc)Return Same Error CodeA Valid DateReturn Excel Serial Number FormatAny Other ValuesReturn 0
ISNUMBER Function To Check Numeric Value

ISNUMBER Function To Check Numeric Value

FORMULAS, More Functions
DEFINITION:- ISNUMBER Function Is Used To Check The Cell Or A Range Value Is A Number. The ISNUMBER Function Returns True When A Cell Contains A Number, For Text Values, Errors, Or Blanks The ISNUMBER Returns False. You Can Use ISNUMBER To Check That A Cell Contains A Numeric Value, Or The Result Generated By Another Function Or Formula Is A Number Or not. As Per This Example We Have Numeric Values In Cells A3 To A5 And Text Values In A Cells A6 To A8. After Applying ISNUMBER Function Please Check The Result Below In Image. NOTE:- Dates And Times Are Considered As Numeric Values, So When You Apply ISNUMBER Function On A Cell It Will Returns True For Them. If Numbers Stored As Text, Then It ISNUMBER Function Will Returns False.
ISNONTEXT Function To Check Cell For Text

ISNONTEXT Function To Check Cell For Text

FORMULAS, More Functions
DEFINITION:- ISNONTEXT Function Is Use To Check If A Value Is Not Text In A Cell Reference. For Every Non Text Cell Value ISNONTEXT Will Return True. For Example:- A Number, A Date, A Time, Etc.. Are Considered As Non-Text. The ISNONTEXT Function Also Returns True For Any Blank Cells And Also If Cells Contain Any Formulas It Will Return As Non-Text. SYNTAX:- =ISNONTEXT (VALUE)
ISLOGICAL Function To Check Logical Value

ISLOGICAL Function To Check Logical Value

FORMULAS, More Functions
DEFINITION:- Use The ISLOGICAL Function To Check If A Value Existing In A Cell Is A Logical Value Or Not. ISLOGICAL Function Returns True When A Cell Contain The Logical Value And Return False For Cell That Contain Any Nonlogical Value or Or Other Value Including Empty Cells. We Can Check Any Value In A Cell To Test It Whether It Is A Logical Value Or Not. Value Can Be In Any form Like Blank (Empty Cell), Error, Logical, Text, Number, Or Reference Value, Or A Name Referring. SYNTAX:- =ISLOGICAL (VALUE)