Search On Google

Sunday, February 10, 2019

What are logical functions in MS Excel

Logical functions in MS Excel?

IFERROR

"=IFERROR(5/0,"Divide by zero error")”
To display custom text when error occures.

IF
"=IF(ISNUMBER(22),"Yes", "No")
Display custom text based on condition true or false.

AND
“=AND(1 > 0,ISNUMBER(1))
For check multiple condition in AND function.

OR
"=OR(D8="admin",E8="cashier")
Check condition true of a given multiple conditions.

TRUE
“=TRUE()

NOT
"=NOT(ISTEXT(0))


IFNA
"=IFNA(D6*E6,0)
To display alternate value if NA occures.

NESTED IF
"=IF(A1="Sunday","GO for movie",IF(B1="Saturday","enjoy weekend","Do your work"))

Nested if is not different from if condition . In nested if if condition occurs in the other outer if.




No comments:

Post a Comment

About Me

My photo
Mumbai, Maharashtra, India