excel Formula / Funcation



Formula \Function

=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