[go: up one dir, main page]
Scribd
Upload
125 views8 pages

Excel Gyan: Logical Function

This document discusses logical functions and operators in Excel including AND, OR, IF, and other information functions like ISNUMBER, ISTEXT, and ISERROR. It provides examples of how to use these functions to evaluate multiple logical conditions and return true/false results. Nested IF functions allow multiple logical tests to return different values. The IFERROR function displays an alternative value if the expression results in an error.

Uploaded by

Bala Ranganath
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
125 views8 pages

Excel Gyan: Logical Function

This document discusses logical functions and operators in Excel including AND, OR, IF, and other information functions like ISNUMBER, ISTEXT, and ISERROR. It provides examples of how to use these functions to evaluate multiple logical conditions and return true/false results. Nested IF functions allow multiple logical tests to return different values. The IFERROR function displays an alternative value if the expression results in an error.

Uploaded by

Bala Ranganath
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
You are on page 1/ 8

EXCEL GYAN

Add EXTRA SKILLS TO YOUR PROFESSIONAL CAREER

LOGICAL FUNCTION
LOGICAL OPERATORS:
> (Greater than)
< (Less than)
<> (Not Equal to)
= (Equal to)
>= (Greater than or Equal to)
<= (Less than or Equal to)

MULTI LOGICAL OPERATORS


AND Function: It allows multiple logical test.(255 LOGICAL TEST)
It checks whether all logical test is true and returns the result as true
Every logical test gives the result as either TRUE/FALSE
Syntax:
AND(Logical1,[Logical2]…………)

Truth Table: AND


Logical 1 Logical 2 Result
1 1 1
1 0 0
0 1 0
0 0 0

Example:
67 1 AND(K33>50,K33<100)

MULTI LOGICAL OPERATORS

OR Function: It allows multiple logical test.(255


It checks whether any of the logical test is true and returns the result as true ,only
Every logical test gives the result as either TRUE/FALSE
Syntax:
OR(Logical1,[Logical2]…………)

Truth Table: OR
Logical 1 Logical 2 Result
1 1 1
1 0 1
0 1 1
0 0 0

Example:
67 1 OR(K51<50,K51<100)

INFORMATION FUNCTIONS:
ISNUMBER:It checks whether a value is number and returns true or false
Syntax: ISNUMBER(Value)
Example: a123 0
ISTEXT:It checks whether a value is text and returns true or false
Syntax: ISTEXT(Value)
Example: a123 1
ISERROR:It checks whether a value is error and returns true or false
Syntax: ISERROR(Value)
Example: #NAME? 1

IF FUNCTION

It check whether condition met and returns one value if true and another value if fals
Syntax: IF(Logical Test,Value if True,[Value if False])
here square bracket says that value if false is optional
Example: 100 Gain

NESTED IF
Allows to use multiple IF statement within a IF statement for multiple logical test
Example: grades display Nested iF
<35--Fail
<50---"C" 100 A
Grade 12 Fail
<75---"B" 54 B
Grade
above 34 Fail
75---"A" 99 A

IFERROR:
It Check whether the expression is error and allows to display any other value instead of error
Syntax: IFERROR(Value,Value if error)
Example: value not divisible IFERROR(SUM(1,3)/0,"value not divisible")
CEL GYAN
LLS TO YOUR PROFESSIONAL CAREER

UNCTION

T)
s true

allows multiple logical test.(255 LOGICAL TEST)


d returns the result as true ,only if all the logical test is false then returns as false
turns true or false

ISNUMBER(L57)
e or false

ISTEXT(L60)
true or false

ISERROR(L63)

if true and another value if false.


alue if False])
alse is optional
IF(L70>50,"Gain","Loss")

ultiple logical test


Nested iF
A
Fail
B
Fail
A

any other value instead of error

not divisible")

You might also like