=Now() - Display
System Date And Time
=Today() - Display
Only System Date
=Min()- Display
The Minimum Value Of Selected Cell
=Max() - Display
The Maximum Value Of Selected Cell
=Count()- Count The Number Of Cell Value From Selected
Cell(Only
Number)
=Counta()- Count
The Number Of Cell Value From
Selected
Cell(Text &Number)
=Average()- Find
The Average Of Selected Value Of Cell
=Product()- Multiplication
Of Selected Cell Value Of
Any
Number
=Sum() - Total The Number Of Selected Cell Value
=Rank() - Find The Rank
=Round()- Net
Figure
=upper()- selected text convert into capital(upper)
=lower()- selected text convert into small(lower)
=if() - check the condition
=len() - count the length of selected string
No comments:
Post a Comment