Logical and reference function Example for beginners

2.Logical & Reference Functions

1.AND FUNCTION

What is the use of And formula?

Tells you what is the reminder after dividing one number with another

Gives you a random number to play with

Rounds a number to nearest decimal you specify

Adds a bunch of numbers

Checks whether all conditions are passed or not

Syntax of And formula:

and(list of conditions)

Examples of Excel And formula:

and(true, false) = false

and(true, true) = true

CLICK HERE FOR EXAMPLE'

2.Countblank Formula'

What is the use of Countblank formula?

Syntax of Countblank formula:
countblank(in this list)

Examples of Excel Countblank formula:
countblank(list) = number of blank cells in the list

CLICK HERE FOR EXAMPLE'

3.Countif Formula

What is the use of Countif formula?

Syntax of Countif formula:
countif(in this range, values meeting this criteria)

Examples of Excel Countif formula:
countif(A1:A20, 1) = counts how many cells have "1" 
countif(A1:A20, "<3") = counts how many cells have less than 3

CLICK HERE FOR EXAMPLE'

4.If Formula

What is the use of If formula?

Syntax of If formula:

if(is-this-true?, do this, or this)

Examples of Excel If formula:

if(5<10,"hello","world") = hello

if(5>10,"hello","world") = world

CLICK HERE FOR EXAMPLE'

5.Large Formula

What is the use of Large formula?

Syntax of Large formula:

large(from this list, nth largest number)

Examples of Excel Large formula:

large(list, 2) = 2nd largest number in the list

CLICK HERE FOR EXAMPLE'

6.Max Formula

What is the use of Max formula?

Syntax of Max formula:

max(of this list of numbers)

Examples of Excel Max formula:

max(1,2,3) = 3

max(A1:A20) = maximum value in the range A1:A20

CLICK HERE FOR EXAMPLE'

7.Min Formula

What is the use of Min formula?

Syntax of Min formula:

min(of this list of numbers)

Examples of Excel Min formula:

min(1,2,3) = 1

min(A1:A20) = minimum value in the range A1:A20

CLICK HERE FOR EXAMPLE