Pilih Fungsi

Sisipkan suatu fungsi dari sebuah rentang sel ke dalam sel saat ini. Fungsi bisa berupa Sum, Average, Minimum, dan Count. Klik dalam suatu sel, klik ikon ini, pilih fungsi dalam daftar tarik turun, dan secara opsional setel rentang sel. Atau pilih beberapa sel tempat nilai fungsi akan disisipkan, lalu klik ikon. Hasil fungsi ditambahkan di bagian bawah rentang.

Ikon Pilih Fungsi

Pilih Fungsi

Pilih Fungsi diterapkan tanpa ada rentang yang dipilih

LibreOfficeDev automatically suggests a cell range, provided that the spreadsheet contains data. If the cell range already contains a function, you can combine it with the new one to yield the function applied to the range data. If the range contains filters, the Subtotal function is inserted instead of the selected function.

Click the Accept icon to use the formula displayed in the input line or Cancel.

Accept Icon

Accept

Icon Cancel

Cancel

Select Function applied on a selected range

When the selected range has two or more rows, the function is calculated for each column. The results are placed in empty cells on the first available row below the range, one result per column.

When the selected range has one row, the function result is placed in the first available cell on the right of the selected range.