C) Date & Time Function
1) Now()
Now function returns the current date and time formatted as a date and time.
Syntax:- =Now()
2) Today()
Today function returns the current date formatted as a date.
Syntax:- =Today()
D) Static Function
1) Count()
Count function counts the number of cells that contain numbers within the list of argument.
Syntax:- =Count(Value1,Value2,Value3,.......)
E.g. =Count(23,30,"Vijay",60,"Ankit",20) Press Enter
Output 4
2) Counta()
Counta function counts the number of cells that are not empty and the value within the list of argument.
Syntax:- =Counta(Value1,Value2,Value3,.......)
E.g. =Counta(23,30,"Vijay",60,"Ankit",20) Press Enter
Output 6
3) Average()
Average function returns the average of its argument.
Syntax:- =Average(No1,No2,No3,......)
E.g. =Average(45,65,70,40,80) Press Enter
Output 60
4) Max()
Max function returns the largest value in a set of value.
Syntax:- =Max(No1,No2,No3,......)
E.g. =Max(45,65,70,400,800) Press Enter
Output 800
5) Min()
Min function returns the smallest value in a set of value.
Syntax:- =Min(No1,No2,No3,......)
E.g. =Min(45,65,70,400,800) Press Enter
Output 45
6) Countif()
Countif function counts the number of cells within a range that meet the given condition of criteria.
Syntax:- =Countif(Range, Criteria)
E.g. =Min(B1:B16,"Moniter") Press Enter
Functions are classified into following categories:-