NEW EXCEL FORMULAS USED IN EXCEL

1.       Present value

                            =COUNTIF(B14:S14,"p")

2.       Absent value

=COUNTIF(B14:S14,"a")

3.       Value code

=CODE("z")

4.       Value count

=COUNT(D27:D33)

5.       Counta value

     =COUNTA(D27:D34)

6.      Count blank value

   =COUNTBLANK(D27:D35)
7. CONCATENATE VALUE
   =CONCATENATE(A37,B37)