Youtube Android,Blogging SEO & Whatsapp Tricks

youtube SEO, tricks for blogger, wordpress tricks for earning money online youtube earning, whatsapp,windows, android & all about new technology.

Showing posts with label Excel Formulas. Show all posts

Excel Date Function


What Does It Do?
This function creates a real date by using three normal numbers typed into separate cells.

Syntax

=DATE(year,month,day)

Formatting


  • The result will normally be displayed in the dd/mm/yy format.
  • By using the Format,Cells,Number,Date command the format can be changed.
  • Countif Function in MS Excel


    What Does It Do ?
    This function counts the number of items which match criteria set by the user.

    Syntax

    =COUNTIF(RangeOfThingsToBeCounted,CriteriaToBeMatched)


  • The criteria can be typed in any of the following ways.
  • To match a specific number type the number, such as =COUNTIF(A1:A5,100)
  • To match a piece of text type the text in quotes, such as =COUNTIF(A1:A5,"Hello")
  • To match using operators surround the expression with quotes, such as =COUNTIF(A1:A5,">100")

  • Formatting

    No special formatting is needed.

    Countblank Formula in Excel For Count Blank Cell


    What Does It Do ?
    This function counts the number of blank cells in a range.

    Syntax

    =COUNTBLANK(RangeToTest)

    Formatting

    No special formatting is needed.

    Example

    The following table was used by a company which was balloting its workers on whether the company should have a no smoking policy.
    Each of the departments in the various factories were questioned.
    The response to the question could be Y or N.
    As the results of the vote were collated they were entered in to the table.

    The =COUNTBLANK() function has been used to calculate the number of departments which
    have no yet registered a vote.

    Excel Convert Function Formula with Examples


    What Does It Do ?

    This function converts a value measure in one type of unit, to the same value expressed in a different type of unit, such as Inches to Centimetres.

    Syntax

    =CONVERT(AmountToConvert,UnitToConvertFrom,UnitToConvertTo)

    Formatting

    No special formatting is needed.

    Example


    The following table was used by an Import / Exporting company to convert the weight and size of packages from old style UK measuring system to European system.


    Abbreviations

    This is a list of all the possible abbreviations which can be used to denote measuring systems.

    These characters can be used as a prefix to access further units of measure.
    Using "c" as a prefix to meters "m" will allow centimetres "cm" to be calculated.

    MS Excel Counta Function


    What Does It Do ?
    This function counts the number of numeric or text entries in a list.
    It will ignore blanks.

    Syntax

    =COUNTA(Range1,Range2,Range3... through to Range30)

    Formatting

    No special formatting is needed.

    Example

    The following table was used by a school to keep track of the examinations taken by each pupil.
    Each exam passed was graded as 1, 2 or 3.
    A failure was entered as Fail.

    The school needed to known how many pupils sat each exam.
    The school also needed to know how many exams were taken by each pupil.

    The =COUNTA() function has been used because of its ability to count text and numeric entries.