Basics functions

download Basics functions

of 9

  • date post

    08-Jul-2015
  • Category

    Education

  • view

    228
  • download

    0

Embed Size (px)

Transcript of Basics functions

  • MS-EXCEL

  • SUM AVERAGE COUNT MAX MIN IF NOW

  • SUM

    .

    : SUM(number1;number2; ...)

  • AVERAGE

    ( ) .

    :AVERAGE(number1;number2;...)

  • COUNT

    , TRUE (), , FALSE ().

    . COUNT, .

    : COUNT(value1;value2;...)

  • .

    : M(number1;number2;...)

  • .

    : MIN(number1;number2;...)

  • IF

    , TRUE (), , FALSE ().

    IF, .

    : IF(logical_test;value_if_true;value_if_false)

  • NOW

    .

    : W()