Scribd
Upload
11 views1 page

Logical Functions

Uploaded by

Marivon Hilado Cagayanan
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
11 views1 page

Logical Functions

Uploaded by

Marivon Hilado Cagayanan
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd

Logical functions

IF function – checks the condition, most common

- =IF(condition, “Statement to return if TRUE”, ”Statement to return if


FALSE”)
- Case 1 – if(logical test, value if true)
- Case 2 - if(logical test, value if true, value if false)
- Case 3 – if

AND function

- Will return only if both satisfies and return FALSE if any of them don’t
satisfy
- =ABD(1st condition, 2nd condition)

OR Function

- If only one condition satisfy return true, if both the condition are not
satisfied it will return FALSE
- =OR(1st condition, 2nd condition)

NOT Function

- Changes the TRUE to FALSE and vice versa


- =NOT(1st condition, 2nd condition)

COUNTING Function

- =COUNT(value 1, [value 2])


- COUNTIF for function
- COUNTA – logical values

IF COMBINED WITH AND, OR, NOT

- AND, =IF(AND(Something is True, Something else is True), Value if True,


Value if False)
- OR, =IF(OR

You might also like