Formula

• These are used to make calculations and make different values in one place.
• Excel is an sheet to store data in table format.
• Its supports all types of data

• Boolean
• Text
• Numbers 
• Date/Time 

• There are may formulas in excel.
• From them below are few.

• Sum :

• To add values of cells.
• =sum(value1,value2,value3).

• Count :

• To count total cells.
• =count(number1,number2,....) (To count numbers)
• =countA(number1, number2,number3,....) (To count count characters).

• Max:

• To know the maximum/largest/highest value.
•  =Max(value1 : valuen).

• Min:

• To know the minimum/lowest/smallest value. 
• =Min(value1 : valuen). 

• Index:

• Index is used to refer same cell value / details in other cell.
• Below Image, I used Index in order to show the lowest and highest product value with product name. 
• =Index(array,row name ,column name).

• Match:

• To equalize to different columns,of same row.
• Below Image, I used Match to equalize product and cost.

• Average:

• To calculate the average of sum numbers. 
• =Average(value1 : valuen).

• Today:

• To enter today's date.
• =Today().

•  Multiply:

• To multiply two different cells
•  =cell1*cell2.

• Concatenate:

• To merge two cells into one cell.
• =concatenate(cell1,cell2). 

• Days:

• To count number of days between two dates.
• =days(enddate,startdate).

• Network Days:

• To count number of day leaving holidays.
• =Networkdays(startdate,enddate). (With fixed two week ends).
• =Networkday.intl(startdate,enddate,weekends,holidays)(wih custom holidays and weekends).