Ogeejjiiwwan LibreOffice Calc keessaa

ogeejjiwwan armaan gadii LibreOffice Calc keessatti fayyadamu dandeessa:

Ogeejjiwwan Herregaa

Ogeejjiwwan kunnen firiiwwan lakkoofsa kennu.

Ogeejjii	Maqaa	Example
+ (Ida'uu)	Ida'ama	1+1
- (Hir'isuu)	Hir'isuu	2-1
- (Hir'isuu)	Fuggisoo	-5
* (urjoo)	Baay'isuu	2*2
/ (haxaaroo)	Hiruu	9/3
% (Parsantii)	Parsantii	15%
^ (arfii hoxxee)	Mul'iseessuu	3^2

Prefix "-" (negation) has a higher precedence than "^" (exponentiation). For example -3^2 equals 9, which is the square of a negative number.

Ogeejjiiwwan dorgii

Ogeejjiiwwan kunnen dhugaa ykn soba deebisuu.

Ogeejjii	Maqaa	Example
= (mallattoo wal qixaa)	walqixa	A1=B1
> (Irra guddaa)	irra guddaa	A1>B1
< (Irra xiqqaa)	Irra xiqqaa	A1<B1
>= (Irra guddaa ykn walqixa)	Irra guddaa ykn walqixa	A1>=B1
<= (irra xiqqaa ykn walqixa)	Irra xiqqaa ykn walqixa	A1<=B1
<> (Walcaalma))	Walcaalma	A1<>B1

Ogeejjiiwwan barruu

Ogeejjiin barruuwwan adda addaa gara barruu tokkootti maka.

Ogeejjii	Maqaa	Example
& (Fi)	walitti fidinsa barruu AND	"Sun" Fi "day"'n "Sunday" ta'a

Wabii ogeejjotaa

Ogeejjootni kunneen hangii man'ee duwwaa,tokko ykn man'eewwan baay'ee kenna.

Hangiin dursaa olaantoo qaba,itti ansuun walkipha,fi xumura irratti walitti makuu qaba.

Ogeejjii	Maqaa	Example
: (Qabxilamee))	Hangii	A1:C108, A:D or 3:13
! (Tuqaa raajefannoo)	Walkipha	SUM(A1:B6!B5:C12) Ida'amaa man'eewwan walkipha keessaa huundaa shallaga;fakkeenya kana keessatti,firiin ida'ama man'eewwan B5 fi B6 kenna.
(Dalduufaa)	Walitti fidinsa ykn walitti makuu	Takes two references and returns a reference list, which is a concatenation of the left reference followed by the right reference. Double entries are referenced twice. =COUNT(A1:B2~B2:C3) counts values of A1:B2 and B2:C3. Note that the cell B2 is counted twice. =INDEX(A1:B2~C1:D2;2;1;2) selects cell C2, that is, the first cell of the second row, first column, of the second range (C1:D2) of the range list.

Ogeejjii

Maqaa

Example

: (Qabxilamee))

Hangii

A1:C108, A:D or 3:13

! (Tuqaa raajefannoo)

Walkipha

SUM(A1:B6!B5:C12)

Ida'amaa man'eewwan walkipha keessaa huundaa shallaga;fakkeenya kana keessatti,firiin ida'ama man'eewwan B5 fi B6 kenna.

(Dalduufaa)

Walitti fidinsa ykn walitti makuu

Takes two references and returns a reference list, which is a concatenation of the left reference followed by the right reference. Double entries are referenced twice.

=COUNT(A1:B2~B2:C3) counts values of A1:B2 and B2:C3. Note that the cell B2 is counted twice.

=INDEX(A1:B2~C1:D2;2;1;2) selects cell C2, that is, the first cell of the second row, first column, of the second range (C1:D2) of the range list.

A reference list is not allowed inside an array expression.