Shallagote assiishshubba
kuni beehaachi Shallagote calc assiishshubba amadino. assiishshu kaa'laacho fanate, choose Surki - assiishshadoori.
[text/scalc/01/func_aggregate.xhp#aggregate_head not found].
This function returns an aggregate result of the calculations in the range. You can use different aggregate functions listed below. The Aggregate function enables you to omit hidden rows, errors, SUBTOTAL and other AGGREGATE function results in the calculation.
[text/scalc/01/func_sumifs.xhp#sumifs_head not found].
Returns the sum of the values of cells in a range that meets multiple criteria in multiple ranges.
ABS
Kiirote co'itte hornyo qolanno.
Ganallo
ABS(Kiiro)
kiiro coitte hornyo shallagama noose kiirooti. Kiironniti coitte hornyo umise hornyo ikkite +/- malaati nookkite.
Lawishsha
=ABS(-56) 56 qolanno.
=ABS(12) 12 qolanno.
=ABS(0) 0 qolanno.
ACOS
kiironnita sasi midaadu fiixoomi kosine galchamme qolanno.
Ganallo
ACOS(Kiiro)
This function returns the inverse trigonometric cosine of Number, that is the angle (in radians) whose cosine is Number. The angle returned is between 0 and PI.
Digirrate giddo angile qolate, DEGREES assiishsha horoonsiri.
Lawishsha
=ACOS(-1) 3.14159265358979 (PI radiyeese)qolanno
=DEGREES(ACOS(0.5)) 60 qolanno. 60 degirra kosiine 0.5 ikkitanno.
ACOSH
kiironnita sasi midaadu fiixoomi kosine galchamme qolanno.
Ganallo
ACOS(Kiiro)
This function returns the inverse hyperbolic cosine of Number, that is the number whose hyperbolic cosine is Number.
Kiiro 1nni roora woy taala noose.
Lawishsha
=ACOSH(1) 0 qolanno.
=ACOSH(COSH(4)) 4 qolanno.
ACOT
uyinoonni kiirora kotanjente (arkotanjente) galchamme qolanno.
Ganallo
ACOT(Kiiro)
This function returns the inverse trigonometric cotangent of Number, that is the angle (in radians) whose cotangent is Number. The angle returned is between 0 and PI.
Digirrate giddo angile qolate, DEGREES assiishsha horoonsiri.
Lawishsha
=ACOT(1) 0.785398163397448 (PI/4 radiyeese qolanno).
=DEGREES(ATAN(1)) 45 qolanno. 45 degirra tanjente 1 ikkitanno.
ACOTH
kiironnita sasi midaadu fiixoomi hayperbolike galchamme qolanno.
Ganallo
ACOTH(Kiiro)
This function returns the inverse hyperbolic cotangent of Number, that is the number whose hyperbolic cotangent is Number.
Kiiro -1 nna 1 ledo sorote gumma lexxitino.
Lawishsha
=ACOTH(1.1) 1.1 hayperbolike kotangenteta, hedotenni 1.52226 galchamme qolanno.
ASIN
kiironnita sasi midaadu fiixoomi kosine galchamme qolanno.
Ganallo
ASIN(Kiiro)
This function returns the inverse trigonometric sine of Number, that is the angle (in radians) whose sine is Number. The angle returned is between -PI/2 and +PI/2.
Digirrate giddo angile qolate, DEGREES assiishsha horoonsiri.
Lawishsha
=ASIN(0) 0 returns.
=ATAN(1) 0.785398163397448 (PI/4 radiyeese qolanno).
=DEGREES(ASIN(0.5)) 30 qolanno. 30 degirra siine 0.5 ikkitanno.
ASINH
kiironnita sasi midaadu fiixoomi siine galchamme qolanno.
Ganallo
ASINH(Kiiro)
This function returns the inverse hyperbolic sine of Number, that is the number whose hyperbolic sine is Number.
Lawishsha
=ASINH(-90) hedotenni -5.1929877 qolanno.
=ASINH(SINH(4)) 4 qolanno.
ATAN
kiironnita sasi midaadu fiixoomi tanjente galchamme qolanno.
Ganallo
ATAN(Kiiro)
This function returns the inverse trigonometric tangent of Number, that is the angle (in radians) whose tangent is Number. The angle returned is between -PI/2 and PI/2.
Digirrate giddo angile qolate, DEGREES assiishsha horoonsiri.
Lawishsha
=ATAN(1) 0.785398163397448 (PI/4 radiyeese qolanno).
=DEGREES(ATAN(1)) 45 qolanno. 45 degirra tanjente 1 ikkitanno.
ATAN2
kiironnita sasi midaadu fiixoomi tanjente x nna y xaaddimmo galchamme qolanno.
Ganallo
ATAN2(NumberX; NumberY)
KiiroX x xaaddimmo hornyooti.
KiiroY y xaaddimmo hornyooti.
ATAN2 sasi midaadu fixoomi galchamme tanjente qolanno, hakkuno angilete (radiyeesete giddo) x-mudukki nnaxuruura bixxille KiiroX, KiiroYnni kaimu geeshsha. Angile -PI nna PI mereero qolantino.
Digirrate giddo angile qolate, DEGREES assiishsha horoonsiri.
Lawishsha
=ATAN2(20,20) 0.785398163397448 (PI/4 radiyeese qolanno).
=DEGREES(ATAN2(12.3,12.3)) 45 qolanno. 45 degirra tanjente 1 ikkitanno.
ATANH
kiironnita sasi midaadu fiixoomi tanjente galchamme qolanno.
Ganallo
ATANH(Kiiro)
This function returns the inverse hyperbolic tangent of Number, that is the number whose hyperbolic tangent is Number.
Kiiro ikkito -1 < number < 1 hajajama noose.
Lawishsha
=ATANH(0) 0 qolanno.
CEILING
kiiro muli tirote batishshi geeshsha doyisanno.
Ganallo
CEILING(Kiiro; Tiro; Gara)
Kiiro aleegge dowa noose kiirooti.
Tiro kiiro ikke batishshu hornyi aleege dowa noosiho.
Mode is an optional value. If the Mode value is given and not equal to zero, and if Number and Significance are negative, then rounding is done based on the absolute value of Number, i.e. negative numbers are rounded away from zero. If the Mode value is equal to zero or is not given, negative numbers are rounded towards zero.
If the spreadsheet is exported to Microsoft Excel, the CEILING function is exported as the equivalent CEILING.MATH function that exists since Excel 2013. If you plan to use the spreadsheet with earlier Excel versions, use either CEILING.PRECISE that exists since Excel 2010, or CEILING.XCL that is exported as the CEILING function compatible with all Excel versions. Note that CEILING.XCL always rounds away from zero. |
Lawishsha
=CEILING(-11;-2) -10 qolanno
=CEILING(-11;-2;0) -10 qolanno
=CEILING(-11;-2;1) -12 qolanno
CEILING.PRECISE
Rounds a number up to the nearest multiple of Significance, regardless of sign of Significance
Ganallo
CEILING.PRECISE(Number; Significance)
Kiiro aleegge dowa noose kiirooti.
Tiro kiiro ikke batishshu hornyi aleege dowa noosiho.
Lawishsha
=CEILING(-11;-2) -10 qolanno
COMBIN
miillate marro higa nookihaxaadooshshuwate kiiro qolanno.
Ganallo
COMBIN(Kiiro1; Kiiro2)
Kiiro1 gambooshshu giddo uduunnu kiirooti.
Kiiro2 gambooshshu giddonni doorroonni uduunni kiirooti.
COMBIN hakuri uduunne doorate aantino doogganni shiqqino kiiro qolanno. Lawishshaho 3 uduunni A, B and C gambooshshu giddo heeriro, 2 uduuunne 3 addi addi doogganni, AB, AC nna BC doora dandaatto.
COMBIN Kiiro1!/(Kiiro2!*(Kiiro1-Kiiro2)!) afirimala: loosu aana hosiisanno
Lawishsha
=COMBIN(3;2) 3. qolanno.
COMBINA
kiirrate marro higino xaadooshshuwate udunnichunniwa cinaancho gambooshshe qolanno.
Ganallo
COMBIN(Kiiro1; Kiiro2)
Kiiro1 gambooshshu giddo uduunnu kiirooti.
Kiiro2 gambooshshu giddonni doorroonni uduunni kiirooti.
COMBINA uduunne doorate addi doogga kiiro qolanno, uduunnunniti taalo aante ikkinokki dargi, nna marro higa fajjantino. Lawishshaho 3 uduunni A, B and C gambooshshu giddo heeriro, 2 uduuunne 6 addi addi doogganni,AA AB, AC, BB, BC nna CC doora dandaatto.
COMBINA (kiiro1+kiiro2-1)! / (kiiro2!(kiiro1-1)!) afirimala loosu aana hosiisanno
Lawishsha
=COMBINA(3;2) 6 qolanno.
CONVERT_OOO
Hornyo mitte bikkote su'minni wole bikkote su'mira soorranno. Soorrate harinsho dirtote giddo aamantino.
Soorate harinsho dirtto mitte higge higgennita awurrooppu womaashshuwanna EUR amaddanno(woriidi lawishsha lai). Haarooa ssiishsha horoonsiratenni EUROCONVERT kuriu womaashshuwa soorrinannita amaalleemmo.
Ganallo
CONVERT_OOO(value;"text";"text")
Lawishsha
=CONVERT_OOO(100;"ATS";"EUR") returns the Euro value of 100 Austrian Schillings.
=CONVERT_OOO(100;"EUR";"DEM") converts 100 Euros into German Marks.
COS
amantino angile (radiyeesete giddo)kosiine qolanno.
Ganallo
COS(Kiiro)
Konne (Sasi midaadu fiixoomi) siine Kiiro, radiyeesete angile giddo qolanno.
Digirrate giddo angilete kosiine qolate, RADIANS assiishsha horoonsiri.
Lawishshua
=COS(PI()/2) 0 qolate, kosiine PI/2 radiyeeseeti.
=COS(RADIANS(60)) 0.5 qolanno, kosiine 60 digirraati.
COSH
kiironnita sasi midaadu fiixoomi kosine galchamme qolanno.
Ganallo
COSH(Kiiro)
Kiironnita hayperbolike kosiine qolanno.
Lawishsha
=COSH(0) hayperbolikete cosiine 0 ikkituro, 1 qolanno.
COT
amantino angile (radiyeesete giddo)kotanjente qolanno.
Ganallo
COT(Kiiro)
(Sasi midaadu fiixoomi) tanjente Kiiro, radiyeesete angile giddo.
Digirrate giddo angilete kotanjente qolate, RADIANS assiishsha horoonsiri.
Angilete tanjentera beehame 1 ledo taaliro kontanjente angileeti.
Lawishshuwa:
=COT(PI()/4) 1 qolate, kotanjente PI/4 radiyeeseeti.
=COT(RADIANS(45)) 1, qolanno, kotanjente 45 digirraati.
COTH
aamantino kiirota (angileta)sasi midaadu fiixoomi kotanjente qolanno.
Ganallo
COTH(Kiiro)
Kiironnita hayperbolike kotanjente qolanno.
Lawishsha
=COTH(1) 1 hayperbolike kotangenteta, hedotenni 1.3130. galchamme qolanno.
CSC
aamantino angileta kosikaante angile(radiyeesete giddo). Angilenniti kosikaante beehame 1 ledo taaliro siinete angileeti
Ganallo
CSC(kiiro)
Konne (Sasi midaadu fiixoomi) siine Kiiro, radiyeesete angile giddo qolanno.
Digirrate giddo angilete koosikaante qolate, RADIANS assiishsha horoonsiri.
Lawishshua
=CSC(PI()/4) hedotenni 1.4142135624, siinetePI/4 radyeese galchamme qolanno.
=COS(RADIANS(30)) 2 qolanno, koskaantenniha 30 digirraati.
CSCH
kiironnita sasi midaadu fiixoomi koskaantete qolanno.
Ganallo
CSCH(kiiro)
Kiironnita hayperbolike koskaante qolanno.
Lawishsha
=CSCH(1) hedotenni 0.8509181282 nna hayperbolikete kosenteha 1 qolanno.
DEGREES
raadeese digirrate soorranno.
Ganallo
DIGIRRA(Kiiro)
Kiiro radeesete angile ikkite digirrate soorrantannote.
Lawishsha
=DDIGIRRA(PI()) 180 digirrara qolanno.
EUROCONVERT
Akala awuropppu gobba womaahshsanna Euro smeereero soorranno.
Ganallo
EUROCONVERT(Hornyo; "womaashshu_wiinni"; "womaashshaho", wo'ma_addimma, sasimidaadimmate_addimma)
Hornyu soorramanno womaashshi bikkaati.
womaashshuwiinni nna womaashshaho womaashsha kawinninna ka'iinni aantensa garinni soorranno. Hakurino borro ikka noonsa, afaminowomaashsha qaalu eronni (lawishshaho, "EUR"). Bikkuwa Euro waaxotenni leellisha)Awurooppu komishiinenni qiniino.
wo'ma addimma doorshaho. Hawamiro woy kapho ikkiro, womaashshaho tonnishshu garinni gumu dowaanno. Wo'ma addimma ikkiro halaaleho, gumuno didowanno.
sasi midaadimmate_addimman doorshaho. Sasi midaadimmate_addimma aamanturo nna >=3, sasi midaadu soorramme karsamme gumi (womaashsha1,EUR,womaashsha2) hatte addimmara dowaanno. Sasi midaadimmate_addimma hawantuha ikkro, karsamino gumi didowaanno. "EUR"womaashshira ikkro, Sasi midaadimmate_addimma sasi midaadimmahasiissinotanna EUR nni EURsoorrate gede kaa'lanno.
Lawishshuwa
=EUROCONVERT(100;"ATS";"EUR") 100 Awusitiraaliyu shilinguwa Eurora soorranno.
=EUROCONVERT(100;"EUR";"DEM") 100 Awusitiraaliyu shilinguwa Germanete maarkera soorranno.
EVEN
Pooseetiive kiiro alinni aantanno wo'ma intigerewanna negeetiive kiiro worora aantanno wo'ma intigerewa doyissanno.
Ganallo
Wo'ma(Kiiro)
Returns Number rounded to the next even integer up, away from zero.
Lawishshua
=Wo'ma(2.3) 4 qolanno.
=Wo'ma(2) 2 qolanno.
=Wo'ma(0) 0. qolanno.
=INT(-0.5) -2 qolanno.
EXP
kaino e kiirote wolqara qolanno. sorrantannokki e hedotenni 2.71828182845904 hornyo afidhino.
Ganallo
EXP(Kiiro)
Kiiro e ka'anno gede assitanno wolqaati.
Lawishsha
=EXP(1) 2.71828182845904, shallagote sorrantannokki e calc addimmara qolanno.
FACT
kiironnita shallagote sinna qolanno.
Ganallo
Halaalanya(Kiiro)
Returns Number!, the factorial of Number, calculated as 1*2*3*4* ... * Number.
=FACT(0) tirotenni1 qolanno.
Negaatiive kiirota shallagote sinna "horweelo tidho" so'ro qolanno.
Lawishsha
=FACT(3) 6 qolanno.
=FACT(0) 1 qolanno.
FLOOR
kiiro hasiisanno muli batishshi doyisanno.
Ganallo
FLOOR(Kiiro; hasiisannoha; Gara)
Kiiro woroogge dowa noose kiirooti.
Hasiisannohu hornyo ikke batishshu kiiro woroogge dowa noosiho.
Mode is an optional value. If the Mode value is given and not equal to zero, and if Number and Significance are negative, then rounding is done based on the absolute value of Number, i.e. negative numbers are rounded towards zero. If the Mode value is equal to zero or is not given, negative numbers are rounded away from zero.
If the spreadsheet is exported to Microsoft Excel, the FLOOR function is exported as the equivalent FLOOR.MATH function that exists since Excel 2013. If you plan to use the spreadsheet with earlier Excel versions, use either FLOOR.PRECISE that exists since Excel 2010, or FLOOR.XCL that is exported as the FLOOR function compatible with all Excel versions. Note that FLOOR.XCL always rounds towards zero. |
Lawishsha
=uulla( -11;-2) -12 qolanno
=uulla( -11;-2;0) -12 qolanno
=uulla( -11;-2;1) -10 qolanno
FLOOR.PRECISE
Rounds a number down to the nearest multiple of Significance, regardless of sign of Significance
Ganallo
FLOOR.PRECISE(Number; Significance)
Kiiro woroogge dowa noose kiirooti.
Hasiisannohu hornyo ikke batishshu kiiro woroogge dowa noosiho.
Lawishsha
=uulla( -11;-2) -12 qolanno
GCD
Lame woy roortino intigereha jawiidi gutu beehaancho qolanno.
Jawiidi gutu beehaanchi hala'lado pooseetiive intigere ikke duuchante aamantino intigerera gatiweelo beehantannote.
Ganallo
GCD(Intigere1; Intigere2; ...; Intigere30)
Intigere1 nni 30 30 geeshsha noo intigere ikkite jawiidi gutu beehaachise shallagama dandaannoho.
Lawishsha
=GCD(16;32;24) guma 8 aanno, korkaatuno 8 jawiidi kiiro ikkite 16, 24 nna 32 gatiweelo beekkanno.
=GCD(B1:B3) B1, B2, B3 bisiccuwa 9amaddino, 12, 9 3 uyitanno.
GCD_EXCEL2003
The result is the greatest common divisor of a list of numbers.
Ganallo
GCD_EXCEL2003(Number(s))
Kiiro(ra) 30 geeshsha no kiirra dirtooti.
Lawishsha
=GCD_EXCEL2003(5;15;25) returns 5.
INT
kiiro worora multanno intigerewa doyisanno.
Ganallo
INT(Kiiro)
Multanno intigerewa doyyitino kiiro qolanno.
Negaatiive kiirraintigerete woroonni worora doyisanno.
Lawishsha
=INT(5.7) 5 qolanno.
=INT(-1.3) -2 qolanno.
ISO.CEILING
Rounds a number up to the nearest multiple of Significance, regardless of sign of Significance
Ganallo
ISO.CEILING(Number; Significance)
Kiiro aleegge dowa noose kiirooti.
Tiro kiiro ikke batishshu hornyi aleege dowa noosiho.
Lawishsha
=CEILING(-11;-2) -10 qolanno
LCM
Mitte woy roortino intigereha shiinqiidi gutu batishsha qolanno.
Ganallo
LCM(Intigere1; Intigere2; ...; Intigere30)
Intigere1 nni 30 30 geeshsha noo intigere ikkite shiimiidi gutu beehaachi shallagantino.
Lawishsha
Tenne512;1024 nna 2000 Intigere 1;2giddo nna 3 borrote saaxinubbara kiiro eittoro, 128000 gumu gede qolama noose.
LCM_EXCEL2003
The result is the lowest common multiple of a list of numbers.
Ganallo
LCM_EXCEL2003(Number(s))
Kiiro(ra) 30 geeshsha no kiirra dirtooti.
Lawishsha
=LCM_EXCEL2003(5;15;25) returns 75.
LN
Returns the natural logarithm based on the sorrantannokki e kiiro kaiminnikalaqamu shallago qolanno. sorrantannokki ehedotenni 2.71828182845904 hornyo afidhino.
Ganallo
LN(Kiiro)
Kiiro hornyo ikkite kalaqamu kiiro shallagama dandaa noose.
Lawishsha
=LN(3) kalaqamu shallago 3 (hedotenni 1.0986)qolanno.
=LN(EXP(321)) 321 qolanno.
LOG
baxxino kaimi kiirote shallagoqolanno.
Ganallo
LOG(kiiro; Kaima)
Kiiro hornyo ikkite shallagose shallagama dandaa noose.
Kaima (doorshu) shallagote shallagamme kaimaati. Hawamiha ikkiro, kaima 10 hedamanno.
Lawishsha
=LOG(10;3) shallagote 10 (hedotenni 2.0959) kaima 3 qolanno.
=LOG(7^4;7) 4 qolanno.
LOG10
kiirote kaima-10 shallago qolanno.
Ganallo
LOG10(Kiiro)
Shallago kaima-10 Kiiroraqolanno.
Lawishsha
=LOG10(5) shallagote -10 (hedotenni 0.69897) kaima 5 qolanno.
MOD
mitte intigere wolete bbeehantanno wote gato qolanno.
Ganallo
MOD(Beehamaancho; Beehaancho)
For integer arguments this function returns Dividend modulo Divisor, that is the remainder when Dividend is divided by Divisor.
Kuni assiishshi beehamaanchu - Beehaanchu * INT(Beehamaanchu/Beehaanchu) gede loosamanno , nna kuni afirimali tidhuwa intigere ikka hoogguro guma aanno.
Lawishsha
=MOD(22;3) 1 qolanno, 22 beehamiro 3.
=MOD(11.25;2.5) 1.25 qolanno.
MROUND
kiiro gamba yiino batishshinni wolete doytinota qolanno.
Ganallo
MROUND(Kiiro; Batishsha)
Returns Number rounded to the nearest multiple of Multiple.
Doorshu loosi batishsha * ROUND(kiiro/Batishsha)ikka noosi.
Lawishsha
=MROUND(15.5;3) 15, 15.5 18 (= 3*6) roore 15 (= 3*5) shiqanno gede qolanno.
=MROUND(1.4;0.5) 1.5 (= 0.5*3)qolanno.
MULTINOMIAL
Returns the factorial of the sum of the arguments divided by the product of the factorials of the arguments.
Ganallo
MULTINOMIAL(Kiiro(ra))
Kiiro(ra) 30 geeshsha no kiirra dirtooti.
Lawishsha
=Batinye malaatta(F11:H11) 1260 qolanno, F11 to H11 2 hornyuwa amadiro, 3 nna 4. kuni =(2+3+4)! / (2!*3!*4!) afirimalira xaadisanno
ODD
Pooseetiive kiiro alinni aantanno xea intigerewanna negeetiive kiiro worora aantanno xea intigerewa doyissanno.
Ganallo
ODD(Kiiro)
Returns Number rounded to the next odd integer up, away from zero.
Lawishsha
=ODD(1.2) 3 qolanno.
=ODD(1) 1 qolanno.
=ODD(0) 1 qolanno.
=ODD(-3.1) -5 qolanno.
PI
3.14159265358979 qolanno, Shallagote hornyi sorrantannokki PI 14 geeshsha tonnishshu darguwaati.
Ganallo
PI()
Lawishsha
=PI() 3.14159265358979 qolanno.
POWER
wole kiirora kaino kiiro qolanno.
Ganallo
POWER(Kaima; Hirre)
Kaimu wolqate Hirrewakainoha qolanno.
Hirrete loosaasincho horoonsiratennimittu dani guma afira dandiinanni ^:
Kaima^Hirre
Lawishsha
=Wolqa(4;3) 64 qolanno, kunino 4 3 wolqaati.
=4^3 4 3 wolqara qolanno.
PRODUCT
Tidhote gede uyinoonni baala kiiro batisanno nna guma qolanno.
Ganallo
PRODUCT(Kiiro1; Kiiro2; ...Kiiro30)
Kiiro 1 te 30 30 tidhuwa ikke gumisi shallagama dandaannoho.
PRODUCT returns kiiro1 * kiiro2 * kiiro3 * qolanno ...
Lawishsha
=PRODUCT(2;3;4) 24 qolanno.
QUOTIENT
beehate loosammehaintijerete kifile qolanno.
Ganallo
QUOTIENT(Woshaancho; kiiraancho)
Returns Intigerete kifile ikkinoha Woshshaanchu kiiraanchoho beehamanno.
QUOTIENT INT(woshaanchu/kiiraanchu)ledo taaloho, babbaxitino so'rote koodduwara rippoorteso'ro hoogguro.
Lawishsha
=Qeechu(11;3) 3 qolanno. Gato 2 baino.
RADIANS
digirra raadeesete soorranno.
Ganallo
RADIANS(Kiiro)
Kiiro digirrate giddo angile ikkite raadiyeesete sorrantannote.
Lawishsha
=Radiyeese(90) 1.5707963267949, hakkuno PI/2 calc halaalimmara qolanno.
mereeroRAND
0 nna 1 mereero noo hedeweelcho kiiro qolanno.
Ganallo
RAND()
This function produces a new random number each time Calc recalculates. To force Calc to recalculate manually press F9.
Shallagantannokki hedeweelcho kiirra kalaqate, konne assiishsha amaddino =RAND() hinkiili, nna use
(ledonna and malaatisantinokkita nna malaatisantino)horoonsiri.Lawishsha
=RAND() 0 nna 1 mereero noo hedeweelcho kiiro qolanno.
RANDBETWEEN
baxxino hakka geeshshi giddo intigerete hedeweelcho kiiro qolanno.
Ganallo
RANDBETWEEN(hundanni; sammote)
Intigerete hedeweelcho kiiro mereero intigerra hundaanni nna Sammote (lamenka amadanno).
This function produces a new random number each time Calc recalculates. To force Calc to recalculate manually press Shift+Command Ctrl+F9.
Shallagantannokki hedeweelcho kiirra kalaqate, konne assiishsha amaddino bisiccuwa hinkiili, nna use
(ledonna and malaatisantinokkita nna malaatisantino)horoonsiri.Lawishsha
=RANDBETWEEN(20;30) 20 nna 30 mereero noo intijere qolanno.
ROUND
kiiro boode kiiro tonnishshu darguwara doyiissanno.
Ganallo
ROUND(Kiiro; kiira)
Tenne Kiirote dowa kiira tonnishshu darguwara qolanno. Kiira hawanturo woy zeero ikkituro, asiishshu muli intigerewa dowaanno. Kiira negaatiive ikkituro, assiishshu muli 10, 100, 1000, etc dowaanno.
Kuni assiishshi muli kiirowa dowaanno. Dorshuwanniha ROUNDDOWN nna ROUNDUP lai.
Lawishsha
=doyicho(2.348;2) 2.35 qolanno
=Dowa(-32.4834;3) -32.483 qolanno. Bisiccote suudishshabaala tonnishuwa la"te soorranno.
=Doyiicho(2.348;0) 2 qolanno.
=Doyicho(2.5) 3 qolanno.
=Doyicho(987.65;-2) 1000 qolanno.
ROUNDDOWN
kiiro worora, zeeronniwa, boode addimmara doyisanno.
Ganallo
Worora Doyiissa(Kiiro; Kiira)
Tenne Kiirote worora dowa (zeeronniwa) kiira tonnishshu darguwara qolanno. Kiira hawanturo woy zeero ikkituro, asiishshu worora intigerenniwa dowaanno. Kiira negaatiive ikkituro, assiishshu worora aananno 10, 100, 1000, etc dowaanno.
Kuni assiishshizeeronniwa dowaanno. Doorshunniha ROUNDUP nna ROUND lai.
Lawishsha
=Worora dowa(1.234;2) 1.23 qolanno.
=Worora dowa(45.67;0) 45 qolanno.
=Worora dowa(-45.67) -45 qolanno.
=Worora dowa(987.65;-2) 900 qolanno.
ROUNDUP
kiiro alira, zeeronniwi fafisa, boode addimmara doyisanno.
Ganallo
Aleege dowa(Kiiro; Kiira)
Tenne Kiirote Aleege dowa (zeeronniwi fafa) kiira tonnishshu darguwara qolanno. Kiira hawanturo woy zeero ikkituro, asiishshu alira intigerenniwa dowaanno. Kiira negaatiive ikkituro, assiishshu alira aantanno 10, 100, 1000, etc dowaanno.
Kuni assiishshi zeeronniwi fafe dowaanno. Doorshunniha ROUNDDOWN and ROUND lai.
Lawishsha
=Aleege dowa(1.1111;2) 1.12 qolanno.
=Aleege dowa(1.2345;1) 1.3 qolanno.
=Aleege dowa(45.67;0) 46 qolanno.
=Aleege dowa(45.67) -46 qolanno.
=Aleege dowa(987.65;-2) 1000 qolanno.
SEC
aamantino angileta sekaante angile(radiyeesete giddo). Angilenniti kosikaante beehame 1 ledo taaliro kosiinete angileeti
Ganallo
SEC(Kiiro)
Konne (Sasi midaadu fiixoomi) siine Kiiro, radiyeesete angile giddo qolanno.
Digirrate giddo angilete sekaante qolate, RADIANS assiishsha horoonsiri.
Lawishshua
=CSC(PI()/4) hedotenni 1.4142135624, kosiinete PI/4 radyeese galchamme qolanno.
=SEC(RADIANS(60)) 2 qolanno, sekantenniha 60 digirraati.
SECH
kiironnita sasi midaadu fiixoomi sekaante qolanno.
Ganallo
SECH(Kiiro)
Hayperbolike sekaante kiiroqolanno.
Lawishsha
=SECH(0) hayperbolikete sekaante 0 ikkituro, 1 qolanno.
SERIESSUM
Ledubba wolqate aantera umi yannaati.
Aanteteledo(x;n;m;xaadooshshuwa) = xaadooshshuwa_1*x^n + xaadooshshuwa_2*x^(n+m) + xaadooshuwa_3*x^(n+2m) +...+ xadooshshuwa_i*x^(n+(i-1)m)
Ganallo
SERIESSUM(X; N; M; xaadooshshuwa)
X wolqate aantera giddo hornyaati.
N hanafote wolqaati
M N ledate lendoonniho
xaadooshuwa xaadooshshuwate aanteeti. Mitte mittente xaadira aantete ledo mitte kifilenni hala'litanno.
SIGN
Kiirote malaate qolanno. Kiiro negaatiive ikkituro 1 qolanno, -1 negaative ikkironna 0 zeero ikkiro.
Ganallo
SIGN(Kiiro)
Kiiro malaatise gumulamino kiirooti.
Lawishsha
=malaate(3.4) 1 qolanno.
=malaate(-4.5) -1 qolanno.
SIN
amantino angile (radiyeesete giddo)siine qolanno.
Ganallo
SIN(Kiiro)
Konne (Sasi midaadu fiixoomi) siine Kiiro, radiyeesete angile giddo qolanno.
Digirrate giddo angilete siine qolate, RADIANS assiishsha horoonsiri.
Lawishsha
=SIN(PI()/2) 1 qolate, siine PI/2 radiyeeseeti.
=SIN(RADIANS(30)) 0.5 qolanno, siine 30 digirraati.
SINH
kiironnita sasi midaadu fiixoomi siine qolanno.
Ganallo
SINH(Kiiro)
Hayperbolike siine kiiroqolanno.
Lawishsha
=SINH(0) hayperbolikete siine 0 ikkituro, 0 qolanno.
SQRT
kiironnita pooseetiive kiirote wolqa hunda qolanno.
Ganallo
SQRT(Kiiro)
Poseetiive kiirote wolqa hunda Kiiroraqolanno.
Kiiro poseetiive ikka noose.
Lawishsha
=SQRT(16) 4 qolanno.
=SQRT(-16) horoweello tidhibba so'ro qolanno.
gummaSQRTPI
kiirote wolqa hunda (PI hige kiiro)qolanno.
Ganallo
SQRTPI(Kiiro)
Poseetiive kiirote wolqa hunda (PI batisantannota Kiirora)qolanno. batisantannota) qolanno.
Kuni SQRT(PI()*kiiro)taalanno.
Lawishsha
=SQRTPI(2) (2PI)kiirote wolqa hundaqolanno, hedotenni 2.506628 ikkanno.
SUBTOTAL
cinaancho xaphooma shallagi. Hakka geeshshi cinaancho xaphooma amadinoha ikkiro, ledote shallagubba dihasiissanno. Konne assiishsha AutoFilters ledo kiirrate giddora meemiissamino maareekkota callamassate horoonsiri.
Ganallo
SUBTOTAL(Assiishsha; Hakka geeshsha)
Assiishshu aantanno assiishshubba giddo mittu assiishshi kiirooti:
Assiishshu mashalaqisaancho (includes hidden values) |
Function index (ignores hidden values) |
Assiishsha |
1 |
101 |
AVERAGE |
2 |
102 |
COUNT |
3 |
103 |
COUNTA |
4 |
104 |
MAX |
5 |
105 |
MIN |
6 |
106 |
PRODUCT |
7 |
107 |
STDEV |
8 |
108 |
STDEVP |
9 |
109 |
SUM |
10 |
110 |
VAR |
11 |
111 |
VARP |
Use numbers 1-11 to include manually hidden rows or 101-111 to exclude them; filtered-out cells are always excluded.
Hakka geeshshi bisiccuwa amaddino hakka geeshshaati.
Lawishsha
You have a table in the cell range A1:B6 containing a bill of material for 10 students. Row 2 (Pen) is manually hidden. You want to see the sum of the figures that are displayed; that is, just the subtotal for the filtered rows. In this case the correct formula would be:
A |
B |
|
1 |
ITEM |
QUANTITY |
2 |
Pen |
10 |
3 |
Pencil |
10 |
4 |
Notebook |
10 |
5 |
Rubber |
10 |
6 |
Sharpener |
10 |
=SUBTOTAL(9;B2:B6) returns 50.
=SUBTOTAL(109;B2:B6) returns 40.
SUM
Baala kiirra bisiccote hakka geeshshi giddo ledi.
Ganallo
SUM(Kiiro1; Kiiro2; ...Kiiro30)
Kiiro 1 te 30 30 tidhuwa ikke ledose shallagama dandaannoho.
Lawishsha
Tenne2; 3 kiirra eittoro nna 4kiiro 1; 2 nna 3 giddo borrote saaxinnara, 9 gumu gede qolantino.
=SUM(A1;A3;B5) sase bisiccuwa ledo shallaganno. =SUM (A1:E10) A1 to E10 bisicco hakka geeshshi giddo baala bisiccuwa ledo ledo.
AND xaaddino ikkitubba SUM() assiishshi ledo aantanno ikkito giddo horoonsirama dandiitanno:
Lawishsha adha: kaarinna shaete giddora eessi. Caccafo A kaarinete barru hornya, Caccafo B geeshshuwa amaddino. afirimala afira hasirittorbaala geeshshuwa baxxino aganira calla baala geeshshuwa xaphoomaho qola horoonsira dandaatto, la.w. geeshsha calla yannate >=2008-01-01 nni <2008-02-01 qola. Hakka geeshshi barru hornyuwa ledo A1:A40 diwanno, hakka geeshshi B1:B40 giddo xaphooma geeshshuwa amadino. C1 hanafote barra, 2008-01-01, kaarinnate ledo amadino nna C2 barra, 2008-02-01, seeda yanna diamadanno.
Aananno afirimala diru afirimali geede ei:
=Ledo((A1:A40>=C1)*(A1:A40<C2)*B1:B40)
In order to enter this as an array formula, you must press the Shift+Command + Ctrl+ Enter keys instead of simply pressing the Enter key to close the formula. The formula will then be shown in the Formula bar enclosed in braces.
{=SUM((A1:A40>=C1)*(A1:A40<C2)*B1:B40)}
Afirimalu kaima asirinohu heesishshu gumi halaale 1 ikkiro wonshiworcho xaadino nna xaada hoogiro 0 ikkanno. Mittu mittunku heewishshu guma diru gede siikkisanna matirkisete batishshi giddo horoonsira, nna goofimarchoho mittu mittunku hornyuwagumu matirkise aate xaphisama noose.
SUMIF
Baxxitino bisiccuwa uyinoonni wonshiworchinni ledanno. Boode hornyo hasatto yannara kuni assiishshi hakka geeshsha soroowate kaa'lanno.
Ganallo
SUMIF(Hakka geeshsha; Wonshiworcho; SumRange)
Hakka geeshshi wonshiworchu loosa noosi hakka geeshshaati.
Wonshiworcho bisicco giddo hasate wonshiworcho leellishanno, woy hasate wonshiworcho umosiiti. Wonshiworchu afirimalu giddo borreessamiro, lame bicamuwaenni huxxama noosi.
SumRange adhantino hornyuwa hakka geeshshaati. Kuni eishshi leella hoogiro, hakka geeshshi giddo anfanni hornyuwa ledantinote.
SUMIF maqishunni amadamino loosaasincho (~) wonshiworchu eishshi giddo calla, nna doorshu SumRange aamama hoogiro calla irkisanno. |
Lawishsha
Negaatiive kiirra calla ledate: =SUMIF(A1:A10;"<0")
=SUMIF(A1:A10;">0";B1:10) - hornyuwa B1:B10 hakka geeshshiwiinni calla ledate A1:A10 giddo xaaddino hornyuwa >0.
COUNTIF() roore ganallo lawishshubba that can be used with SUMIF()ledo kaa'la dandiitannota lai.
SUMSQ
doyichote kiirra ledo(doychote tirubba xaphoomu ale higa) shallaga hasirittoro, borrote barubba giddora eessi.
Ganallo
SUMSQ(Kiiro1; Kiiro2; ...Kiiro30)
Kiiro 1 te 30 30 tidhuwa ikke doyichote ledo shallagama dandaannoho.
Lawishsha
Tenne2; 3 kiirra eittoro nna 4 kiiro 1; 2 nna 3 giddo borrote saaxinnara, 29 gumu gede qolantino.
TAN
amantino angile (radiyeesete giddo)tanjente qolanno.
Ganallo
TAN(Kiiro)
(Sasi midaadu fiixoomi) tanjente Kiiro, radiyeesete angile giddo.
Digirrate giddo angilete tanjente qolate, RADIANS assiishsha horoonsiri.
Lawishsha
=TAN(PI()/4) 1 qolate, tanjente PI/4 radiyeeseeti.
=TAN(RADIANS(45)) 1, qolanno,tanjente 45 digirraati.
TANH
kiironnita hayperbolike tanjente qolanno.
Ganallo
TANH(Kiiro)
Hayperbolike tanjente kiiroqolanno.
Lawishsha
=TANH(0) hayperbolikete tanjente 0 ikkituro, 0 qolanno.
TRUNC
kiiro tonnishshu darguwa hoolatenni mure haransa.
Ganallo
TRUNC(Kiiro; kiira)
Kiirote roore kiira tonnishshu darguwa qolanno. Hasiissannokki tonnishshu darguwa shotu garinni, malaatu baxxikkinni baino.
TRUNC(Kiiro; 0) INT(Number) pooseetive kiiro gede worantino , ikkolana negaative kiirora zeeronniwa hige dowaanno.
The visible decimal places of the result are specified in LibreOffice - Preferences Tools - Options - LibreOffice Calc - Calculate. |
Lawishsha
=TRUNC(1.239;2) 1.23 qolanno. 9 baino.
=TRUNC(-1.234999;3) -1.234 qolanno. 9wa baala baino.