Entering Formulae in the Formula Bar

Formulu možeš unieti na više načina: koristeći ikone, ili kucanjem na tastaturi ili kombinacijom oba.

  1. Klikni ćeliju u koju želiš da uneseš formulu.

  2. Klikni Funkcija ickonu u Formula Bar-u.

    Sada ćeš vidjeti znak jednakosti na liniji za unos i mozeš početi unositi formulu.

  3. Nakon unošenja potrebnih vrijednosti pritisni Enter ili klikni Prihvati da uneses rezultat u aktivnu ćeliju. Ako zeliš da očistiš unos u liniju unosa, pritisni Escape ili klikni Odustani.

Mozeš unijeti vrijednosti i formulu direktno u ćeliju, iako ne mozeš vidjeti kursor unosa. Formula mora uvijek poceti sa znakom jednakosti.

You can also press the + or - key on the numeric keyboard to start a formula. NumLock must be ""on"". For example, press the following keys in succession:

+ 5 0 - 8 Enter

You see the result 42 in the cell. The cell contains the formula =+50-8.

Note Icon

If you are editing a formula with references, the references and the associated cells will be highlighted with the same color. You can now resize the reference border using the mouse, and the reference in the formula displayed in the input line also changes. Show references in color can be deactivated under - LibreOffice Calc - View.


Tip Icon

If you would like to view the calculation of individual elements of a formula, select the respective elements and press F9. For example, in the formula =SUM(A1:B12)*SUM(C1:D12) select the section SUM(C1:D12) and press F9 to view the subtotal for this area.


If an error occurs when creating the formula, an error message appears in the active cell.

Formula bar

D'oh! You found a bug (text/scalc/guide/multitables.xhp#multitables not found).