FORMULA IN EXCEL

Formulae:
An expression which calculates the value of a cell.

Excel formulaes:
COUNT:
Count the number of cells that contain numbers with count function.

COUNTIF:
Count cells based on one criteria.

COUNTIFS:
Counting cells on multiple criteria.

Logical:
IF:
Checks whether condition is met and returns one value if true and returns another value if false.

AND:
Returns true if all conditions are true.
Returns false if any of the condition is false.

OR:
Returns true if any of the condition is true.
Returns false if all conditions are false.

CELL REFERENCES:
RELATIVE REFERENCES:

DATE AND TIME:
To enter date use "/" and "-" characters.
To enter time use ":"
We can enter date and time in one cell.

YEAR, MONTH, DAY:
To get the year of a date use year function.

DATE:
Adding number of days to date.

CURRENT DATE AND TIME:

TEXT:
JOIN:
To join strings use & operator.

LEFT:
To extract left most characters from the string use LEFT function.

RIGHT:
To extract right most characters from the string use RIGHT function.

MID:
To extract a substring starting in the middle of a string use MID function.

LEN:
To get the length of the string use LEN function.

FIND:
Find the position of a substring in a string use FIND function.

SUBSTITUTE:
To replace existing text with a new text in a string use SUBSTITUE function.

ROUND:
Round a number to two decimal point.     

Round a number to one decimal place.

Round a number to nearest integer.

Round a number to nearest 10.

Round a number to nearest 100.

ROUNDUP:
Rounds a number up away from zero.

ROUNDDOWN:
Rounds a number down towards zero.