abc MICROSOFT EXCEL 2010 - Functions Fx

Functions make work easier. They allow for simpler writing of formulas and calculations. By pressing the button a dialogue window is prompted INSERT FUNCTION:


Picture 1. INSERT FUNCTION dialogue window

The following table contains examples of functions:

Function

  

Tip funkcije

   

AND

  

Logical

    

AVERAGE

  

Statistical

    

COUNT

  

Statistical

    

COUNTA

  

Statistical

    

MAX

  

Statistical

    

IF

  

Logical

    

SUM

  

Mathematics and trigonometry /MATH & TRIG/

   

PRODUC

  

Mathematics and trigonometry /MATH & TRIG/

   

Functions links:

Index