natgillin/translations-raw huggingface dataset:
Tolar
Dolar ($)
SIT
STD
Solomon Islands
Solomonsko otočje
Peseta
Trenutna vrijednost
Pts
Tčk
Sri Lanka
Šri Lanka
Syrian Arab Republic
Syrian Arab Republic
Tanzania, United Republic Of
Tanzania, Ujedinjena Republika
Pa'anga
Promijeni ime
TOP
VRH
Trinidad And Tobago
Trinidad i Tobago
Manat
Siječanj
Turks And Caicos Islands
Turks i Caicos otočje
Pound Sterling
Podvuci
Virgin Islands
Djevičanski Otoci
Western Sahara
Zapadna Sahara
Yugoslavia
Jugoslavija (više ne postoji)
Any kind of value
Bilo kakva vrijednost
Return type: %1
Tip:
Comment: %1
Komentar:
Type: %1
Tip:
Related Functions
Sintaksa
Sheet%1
Izaberite
This document has no sheets (tables).
Ova funkcija nema niti jedan parametar.
& Edit
Uređivanje
Fill
& Ispuna
Clear
Godina
Delete
Obriši redove
& Insert
Umetni redove
& External Data
& Vanjski podaci
Merge Cells
Spoji ćelije
& Row
& Red
& Column
& Stupac
& Sheet
& List
& Print Range
& Ispisujem
Filter
datoteka
& Settings
Znakovni niz
Edit
Valjanost...
Font
Format
Colour/ BorderNAME OF TRANSLATORS
Boja/ RubNAME OF TRANSLATORS
John Knight, Dwayne BaileyEMAIL OF TRANSLATORS
Anđelko Iharoš, Darko Bednjanec, Denis Lackovic, Hrvoje Spoljar, Igor Jagec, Ivan Jankovic, Jerko Škifić, Nikola Planinac, Robert Pezer, Robert Vuković, Sasa Poznanovic, Vedran Rodic, Zoran JankovicEMAIL OF TRANSLATORS
anarchist_tomato@herzeleid. net, dwayne@translate. org. za
lokalizacija@ linux. hr, lokalizacija@ linux. hr, lokalizacija@ linux. hr, lokalizacija@ linux. hr, lokalizacija@ linux. hr, lokalizacija@ linux. hr, lokalizacija@ linux. hr, lokalizacija@ linux. hr, lokalizacija@ linux. hr, lokalizacija@ linux. hr, lokalizacija@ linux. hr, lokalizacija@ linux. hr, lokalizacija@ linux. hr
Database Selector
Sintaksa
Data Area
Baza podataka
Area:
Područje:
First row as label
Prvi redak kao labela
First column as label
& Prvi redak sadrži zaglavlje
Data Format
Format datuma
Data sets in columns
Umetni stupace
Fraction
Razlomak
Money
Novac
Date and Time
Datum i Vrijeme
Postfix:
Sufiks
Roman
Rumunjska
Italic
Italija
Weight:
Težina:
Strike out
Prekriženo
Horizontal
Format
Centre
Centrirano
Vertical
Uspravni tekst
Middle
Sredina
Text Option
Boja teksta
Wrap text
Omotaj tekst
Vertical text
Uspravni tekst
Indent
Uvučeno
Merge cells
Spoji ćelije
Size of Cell
Veličina ćelije
Default height (%1)
Uobičajena visina (20)
Default width (%1)
Uobičajena širina (60)
& Do not print text
& Ne ispisuj tekst
Hide & all
& Sakrij sve
& Protected
& Zaštićeno
& Hide formula
& Sakrij formulu
Content
Komentar
Everything
Sve
Everything without border
Sve bez okvira
Addition
Dodatak
Subtraction
Oduzimanje
Use function:
Koristi funkciju:
At each change in:
Za svaku promjenu u:
Options
Operacija
& Page break between groups
& Prijelom stranice između grupa
& Summary below data
& Sažetak ispod podataka
File Options
Opće Mogućnosti
Number of entries in Recent Files list:
Broj & nedavno korištenih datoteka
Create backup files
Napravi & tabelu
Function shown in status bar:
& Prikaži traku stanja
Unit:
vrijeme
Colours
Boja
Grid:
& Rub
Custom...
Prilagođeno
Page border:
Prikaži rubove stranice
Print settings
Ispisivanje
Grid
& Rub
Comment indicator
Prikaži broj stupca
Charts
& Grafikon
Objects
& Objekt...
Zero values
Početna vrijednost
Formula indicator
Prikaži broj stupca
Headers
Zaglavlje
Page order
Prikaži rubove stranice
Centre horizontally
Spoji ćelije
Centre vertically
Spoji ćelije
Columns from
Stupci
Rows from
& Red
to
Idi na ćeliju
Scaling
Španjolska
Page limits:
Donja granica
SheetPropertiesBase
Ostalo...
Right to Left
Poravnaj lijevo
Show comment indicator
Prikaži broj stupca
Use & LC mode
& LC mode
Show page & borders
& Prikaži rubove stranice
& Convert first letter to uppercase
Promijeni prvo slovo u & veliko
& Hide zero
Sakrij tabelu
Show & formula
Prikaži formular
Show column as & numbers
Prikaži broj stupca
Show formula & indicator
Prikaži broj stupca
Show & grid
Prikaži & mrežu
& Automatic recalculation
& Automatsko preračunavanje
All Sheets
Sakrij tabelu
Active Sheet
Sakrij tabelu
Selected Sheets:
Zaštita lista
Available sheets
Sakrij tabelu
Available Sheets
Sakrij tabelu
Selected Sheets
Zaštita lista
Select all sheets
Stil tabele
Move selected sheet to the top
Broj neuspješnih pokušaja
Select sheets
Izaberite pismo
Move selected sheet up
Pomakni prema lijevo
Remove sheets
Ukloni ćeliju
Move selected sheet down
Pomakni prema lijevo
Clear Selection
Izbornik formule
Move selected sheet to the bottom
Broj neuspješnih pokušaja
You cannot change a protected sheet < "and" >
NE možete ovdje odreditti tablicu! < "and" >
page
stranica
pages
stranice
file
datoteka
name
ime
time
vrijeme
date
datum
email
e- pošta
sheet
list
Default
Rezultat
True
Uto
FalseError: circular formula dependency
BazaError: circular formula dependency
#PARSE! Error: invalid cell/ array reference
Error: invalid cell/ array reference
true
if true
false
if false
am
Guam
Bit Operations
Operacija
First number
Broj
Second number
Broj
BITAND(value; value)
atan2 (vrijednost; vrijednost)
BITOR(value; value)
atan2 (vrijednost; vrijednost)
BITXOR(value; value)
AND (vrijednosti; vrijednosti;...)
BOOL2STRING(value)
BOOL2STRING( vrijednost)
BOOL2STRING(true) returns "True"
fact( 0) vraća 1
BOOL2STRING(false) returns "False"
BOOL2STRING( neistinito) vraća "neistinito"
INT2BOOL(value)
Krajnja vrijednost
INT2BOOL(1) returns true
fact( 0) vraća 1
INT2BOOL(0) returns false
fact( 0) vraća 1
OR(INT2BOOL(1); false) returns true
fact( 0) vraća 1
BOOL2INT(value)
BOOL2INT( vrijednost)
BOOL2INT(True) returns 1
BOOL2INT( True) vraća 1
BOOL2INT(False) returns 0
BOOL2INT( False) vraća 0
Number to convert into string
Broj pokušaja
NUM2STRING(value)
Krajnja vrijednost
NUM2STRING(10) returns "10"
fact( 0) vraća 1
NUM2STRING(2.05) returns "2.05"
fact( 0) vraća 1
The CHARTOASCII() function returns the ASCII code for the given character.
Standardno
CHARTOASCII(value)
Krajnja vrijednost
CHARTOASCII("v ") returns 118
fact( 0) vraća 1
ASCIITOCHAR(value)
ASCIITOCHAR( vrijednost)
ASCIITOCHAR(118) returns "v"
ASCIITOCHAR( 118) vraća "v"
ASCIITOCHAR(75; 68; 69) returns "KDE"
ASCIITOCHAR( 118) vraća "v"
Value in X
Vrijednost
Value in Y
Vrijednost
POLR(12; 12) returns 16.9705
fact( 0) vraća 1
POLR(12; 0) returns 12
fact( 0) vraća 1
POLA(12; 12) returns 0.78539816
fact( 0) vraća 1
POLA(12; 0) returns 0
fact( 0) vraća 1
POLA(0; 12) returns 1.5707
fact( 0) vraća 1
Angle (radians)
Kut u (rad)
CARX(12; 1.5707) returns 0.00115592
CARX( 12; 1. 5707) vraća 0. 00115592
CARX(12; 0) returns 12
CARX( 12; 0) vraća 12
DECSEX(double)
Krajnja vrijednost
DECSEX(1.6668) returns 1:40
fact( 0) vraća 1
DECSEX(7.8) returns 7:47
fact( 0) vraća 1
Minutes
Minuta
SEXDEC(1; 5; 7) returns 1.0852778
fact( 0) vraća 1
DECSEX("8:05 ") returns 8.08333333
fact( 0) vraća 1
CARY(12; 1.5707) returns 12
CARY( 12; 1. 5707) vraća 12
CARY(12; 0) returns 0
CARY( 12; 0) vraća 0
ROMAN(Number)
Broj
ROMAN(99) returns "XCIX"
fact( 0) vraća 1
ROMAN(-55) returns "Err"
fact( 0) vraća 1
Numeral
Broj
The ARABIC() function converts a roman numeral into a number.
Standardno
ARABIC(Numeral)
ARABIC( Numeriči)
ARABIC("IV ") returns 4
ARABIC ("IV") vraća 4
ARABIC("XCIX ") returns 99
ARABIC ("XCIX") vraća 99
Range marking the database
Spajam se na bazu...
String marking the column in the database
Spajam se na bazu...
Range marking the conditions
Spajam se na bazu...
Range containing the pivot table
Spajam se na bazu...
Date & Time
Datum i Vrijeme
Method (optional)
Boja teksta
WEEKDAY(date; method)
& Podaci
WEEKDAY("2002-02-22 "; 2) returns 5
fact( 0) vraća 1
Date1
Datum1
Date2
Datum2
DAYS360(date1; date2; method)
& Podaci
DAYS360("2/ 22/ 2002 ";" 4/ 21/ 2002 "; FALSE) returns 59
fact( 0) vraća 1
TIMEVALUE(time)
len (tekst)
TIMEVALUE("10:05:02 ") returns 0.42
fact( 0) vraća 1
DATEVALUE(date)
len (tekst)
DATEVALUE("2/ 22/ 2002 ") returns 37309
fact( 0) vraća 1
EDATE(date; months)
Broj
EDATE("2/ 22/ 2002 "; 3) returns" 5/ 22/ 2002 "
fact( 0) vraća 1
EDATE("3/ 31/ 2002 "; -1) returns" 2/ 28/ 2002 "
fact( 0) vraća 1
EOMONTH(date; months)
Broj
EOMONTH("2/ 22/ 2002 "; 3) returns" 5/ 31/ 2002 "
fact( 0) vraća 1
EOMONTH("3/ 12/ 2002 "; -1) returns" 2/ 28/ 2002 "
fact( 0) vraća 1
EOMONTH("3/ 12/ 2002 "; 0) returns" 3/ 31/ 2002 "
fact( 0) vraća 1
YEAR(date)
& Podaci
YEAR("2/ 22/ 2002 ") returns 2002
fact( 0) vraća 1
YEAR(2323.1285) returns 1906
fact( 0) vraća 1
MONTH(date)
Broj
MONTH("2/ 22/ 2002 ") returns 2
fact( 0) vraća 1
MONTH(2323.1285) returns 5
fact( 0) vraća 1
DAY(date)
& Podaci
DAY("2/ 22/ 2002 ") returns 22
fact( 0) vraća 1
DAY(2323.1285) returns 11
fact( 0) vraća 1
HOUR(time)
len (tekst)
HOUR("22:10:12 ") returns 22
fact( 0) vraća 1
HOUR(0.1285) returns 3
fact( 0) vraća 1
MINUTE(time)
len (tekst)
MINUTE("22:10:12 ") returns 10
fact( 0) vraća 1
MINUTE(0.1234) returns 57
fact( 0) vraća 1
SECOND(time)
len (tekst)
SECOND("22:10:12 ") returns 12
fact( 0) vraća 1
SECOND(0.1234) returns 42
fact( 0) vraća 1
Second date value
Početna vrijednost
Calculation mode
Proračunski mod
WEEKS(date2; date1; mode)
& Podaci
MONTHS(date2; date1; mode)
& Podaci
YEARS(date2; date1; mode)
& Podaci
The DAYS() function returns the difference between two dates in days.
Standardno
DAYS(date2; date1)
& Podaci
DAYS("2002-02-22 ";" 2002-02-26 ") returns 4
fact( 0) vraća 1
Year
Godine
The DAYOFYEAR() function returns the number of the day in the year (1... 365).
Standardno
DAYOFYEAR(2000; 12; 1) returns 336
fact( 0) vraća 1
DAYOFYEAR(2000; 2; 29) returns 60
fact( 0) vraća 1
The DATE() function returns the date formatted with local parameters.
Standardno
The TIME() function returns the time formatted with local parameters.
Standardno
TIME(10; 2; 2) returns 10:02:02
fact( 0) vraća 1
TIME(10; 70; 0) returns 11:10:0
fact( 0) vraća 1
TIME(10; -40; 0) returns 9:20:0
fact( 10) vraća 3628800
The HOURS() function returns the value of the hours in a time expression.
Standardno
HOURS(time)
len (tekst)
HOURS("10:5:2 ") returns 10
fact( 0) vraća 1
ISLEAPYEAR(year)
fact( 0) vraća 1
ISLEAPYEAR(2000) returns True
fact( 0) vraća 1
The function DAYSINMONTH() returns the number of days in the given year and month.
Standardno
DAYSINMONTH(year; month)
Broj
DAYSINMONTH(2000; 2) returns 29
fact( 0) vraća 1
DAYSINYEAR(year)
fact( 0) vraća 1
DAYSINYEAR(2000) returns 366
fact( 0) vraća 1
WEEKSINYEAR(year)
fact( 0) vraća 1
WEEKSINYEAR(2000) returns 52
fact( 0) vraća 1
The MINUTES() function returns the value of the minutes in a time expression.
Standardno
MINUTES(time)
len (tekst)
MINUTES("10:5:2 ") returns 5
fact( 0) vraća 1
The SECONDS() function returns the value of the seconds in a time expression.
Standardno
SECONDS(time)
len (tekst)
SECONDS("10:5:2 ") returns 2
fact( 0) vraća 1
Number of day in week (1..7)
Broj dana u tjednu (1.. 7)
Number of month (1..12)
Broj dana u tjednu (1.. 7)
The MONTHNAME() function returns the name of the month (1... 12).
Standardno
MONTHNAME(number)
Broj
MONTHNAME(5) returns May
fact( 0) vraća 1
CURRENTDATE() returns "Saturday 13 April 2002"
fact( 0) vraća 1
The TODAY() function returns the current date.
Standardno
TODAY()
& Podaci
TODAY() returns "Saturday 13 April 2002"
fact( 0) vraća 1
NOW()
ENT (x)
NOW() returns "Saturday 13 April 2002 19:12:01"
fact( 0) vraća 1
The CURRENTDATETIME() function returns the current date and time.
Standardno
CURRENTDATETIME() returns "Saturday 13 April 2002 19:12:01"
fact( 0) vraća 1
The CURRENTTIME() function returns the current time formatted with local parameters.
Standardno
CURRENTTIME() returns "19:12:01"
CURRENTTIME () vraća "19: 12: 01"
EASTERSUNDAY(year)
fact( 0) vraća 1
EASTERSUNDAY(2003) returns "20th April 2003"
fact( 0) vraća 1
The WEEKNUM() function returns the non-ISO week number in which the date falls into.
Standardno
WEEKNUM(date; method)
& Podaci
First date
Broj
Second date
Početna vrijednost
interval
& Općenito
The DATEDIF() function returns the difference between two dates.
Standardno
Start date
Počni od linije:
The WORKDAY() function returns the date which is working days from the start date.
Standardno
End date
datum
The NETWORKDAY() function returns the number of working days between startdate and enddate.
Standardno
DATE2UNIX(date)
len (tekst)
DATE2UNIX("01/ 01/ 2000 ") returns 946,684,800
fact( 0) vraća 1
Unixtime
vrijeme
UNIX2DATE(0) returns 1970-01-01
CURRENTTIME () vraća "19: 12: 01"
Engineering
Inžinjerstvo
MinLength
Duljina
BASE(128; 8) returns "200"
BASE( 128; 8) vraća "200"
Order of the function
Umetni stupac
The BESSELI() function returns the modified Bessel function In(x).
Standardno
BESSELI(0.7; 3) returns 0.007367374
BESSELI( 0. 7; 3) vraća 0. 007367374
The BESSELJ() function returns the Bessel function.
Standardno
BESSELJ(0.89; 3) returns 0.013974004
BESSELJ( 0. 89; 3) vraća 0. 013974004
BESSELK(3; 9) returns 397.95880
BESSELK( 3; 9) vraća 397. 95880
BESSELY(4; 2) equals 0.215903595
atan2( 0. 5; 1. 0) jednak je 1. 107149
From unit
Iz jedinice
To unit
U jedinicu
The CONVERT() function returns a conversion from one measurement system to another.
Standardno
CONVERT(32; "C"; "F") equals 89.6
ENT( 12. 55) jednako je 12
CONVERT(3; "lbm"; "kg") equals 1.3608
ENT( 12. 55) jednako je 12
CONVERT(7.9; "cal"; "J") equals 33.0757
ENT( 12. 55) jednako je 12
Lower limit
Donja granica
Upper limit
Gornja granica
ERF(0.4) equals 0.42839236
atan2( 0. 5; 1. 0) jednak je 1. 107149
The ERFC() function returns the complementary error function.
Standardno
ERFC(0.4) equals 0.57160764
cos( 0) jednak je 1. 0
The DEC2BIN() function returns the value formatted as a binary number.
Standardno
DEC2BIN(value)
Krajnja vrijednost
DEC2BIN(12) returns "1100"
fact( 0) vraća 1
DEC2BIN(55) returns "110111"
fact( 0) vraća 1
The DEC2HEX() function returns the value formatted as a hexadecimal number.
Standardno
DEC2HEX(value)
Krajnja vrijednost
DEC2HEX(12) returns "c"
fact( 0) vraća 1
DEC2HEX(55) returns "37"
fact( 0) vraća 1
The DEC2OCT() function returns the value formatted as an octal number.
Standardno
DEC2OCT(value)
Krajnja vrijednost
DEC2OCT(12) returns "14"
fact( 0) vraća 1
DEC2OCT(55) returns "67"
fact( 0) vraća 1
The OCT2BIN() function returns the value formatted as a binary number.
Standardno
OCT2BIN(value)
Krajnja vrijednost
OCT2BIN("12 ") returns" 1010 "
fact( 0) vraća 1
OCT2BIN("55 ") returns" 101101 "
fact( 0) vraća 1
The OCT2DEC() function returns the value formatted as a decimal number.
Standardno
OCT2DEC(value)
Krajnja vrijednost
OCT2DEC("12 ") returns 10
fact( 0) vraća 1
OCT2DEC("55 ") returns 45
fact( 0) vraća 1
The OCT2HEX() function returns the value formatted as a hexadecimal number.
Standardno
OCT2HEX(value)
Krajnja vrijednost
OCT2HEX("12 ") returns" A "
fact( 0) vraća 1
OCT2HEX("55 ") returns" 2D "
fact( 0) vraća 1
The BIN2DEC() function returns the value formatted as a decimal number.
Standardno
BIN2DEC(value)
BIN2DEC( vrijednost)
BIN2DEC("1010 ") returns 10
BIN2OCT ("1010") vraća "12"
BIN2DEC("11111 ") returns 31
BIN2OCT ("1010") vraća "12"
The BIN2OCT() function returns the value formatted as an octal number.
Standardno
BIN2OCT(value)
BIN2OCT( vrijednost)
BIN2OCT("1010 ") returns" 12 "
BIN2OCT ("1010") vraća "12"
BIN2OCT("11111 ") returns" 37 "
BIN2OCT ("1010") vraća "12"
The BIN2HEX() function returns the value formatted as a hexadecimal number.
Standardno
BIN2HEX(value)
BIN2HEX( vrijednost)
BIN2HEX("1010 ") returns" a "
BIN2OCT ("1010") vraća "12"
BIN2HEX("11111 ") returns" 1f "
BIN2OCT ("1010") vraća "12"
The HEX2DEC() function returns the value formatted as a decimal number.
Standardno
HEX2DEC(value)
Krajnja vrijednost
HEX2DEC("a ") returns 10
fact( 0) vraća 1
HEX2DEC("37 ") returns 55
fact( 0) vraća 1
The HEX2OCT() function returns the value formatted as an octal number.
Standardno
HEX2OCT(value)
Krajnja vrijednost
HEX2OCT("a ") returns" 12 "
fact( 0) vraća 1
HEX2OCT("37 ") returns" 67 "
fact( 0) vraća 1
The HEX2BIN() function returns the value formatted as a binary number.
Standardno
HEX2BIN(value)
Krajnja vrijednost
HEX2BIN("a ") returns" 1010 "
fact( 0) vraća 1
HEX2BIN("37 ") returns" 110111 "
fact( 0) vraća 1
COMPLEX(1.2; 3.4) returns "1.2+3.4i"
fact( 0) vraća 1
COMPLEX(0; -1) returns "-i"
fact( 0) vraća 1
Complex number
kompleksni broj
IMAGINARY(string)
String
IMAGINARY("1.2+3.4i ") returns 3.4
fact( 0) vraća 1
IMAGINARY("1.2 ") returns 0
fact( 0) vraća 1
IMREAL(string)
String
IMREAL("1.2+3.4i ") returns 1.2
fact( 0) vraća 1
IMREAL("1.2i ") returns 0
fact( 0) vraća 1
IMCOS(string)
String
IMCOS("1+i ") returns" 0.83373-0.988898i "
fact( 0) vraća 1
IMCOS("12i ") returns 81 377.4
fact( 0) vraća 1
IMCOSH(string)
String
IMCOSH("1+i ") returns" 0.83373+0.988898i "
fact( 0) vraća 1
IMCOSH("12i ") returns 0.84358
fact( 0) vraća 1
The IMSIN(string) function returns the sine of a complex number.
Standardno
IMSIN(string)
String
IMSIN("1+i ") returns" 1.29846+0.634964i "
fact( 0) vraća 1
IMSIN("1.2 ") returns -0.536573
fact( 0) vraća 1
The IMSINH(string) function returns the hyperbolic sine of a complex number.
Standardno
IMSINH(string)
String
IMSINH("1+i ") returns" 0.63496+1.29846i "
fact( 0) vraća 1
IMSINH("1.2 ") returns 1.50946
fact( 0) vraća 1
The IMTAN(string) function returns the tangent of a complex number.
Standardno
IMTAN(string)
String
IMTAN("1+i ") returns" 0.27175+1.08392i "
fact( 0) vraća 1
IMTAN("1.2 ") returns 2.57215
fact( 0) vraća 1
The IMTANH(string) function returns the hyperbolic tangent of a complex number.
Standardno
IMTANH(string)
String
IMTANH("1+i ") returns" 1.08392+0.27175i "
fact( 0) vraća 1
IMTANH("1.2 ") returns 0.83365
fact( 0) vraća 1
IMEXP(string)
String
IMEXP("2-i ") returns" 3.99232-6.21768i "
fact( 0) vraća 1
IMEXP("12i ") returns" 0.843854-0.536573i "
fact( 0) vraća 1
The IMLN(string) returns the natural logarithm of a complex number.
Standardno
IMLN(string)
String
IMLN("3-i ") returns" 1.15129-0.321751i "
fact( 0) vraća 1
IMLN("12 ") returns 2.48491
fact( 0) vraća 1
IMLOG2(string)
String
IMLOG2("3+4i ") returns" 2.321928+1.337804i "
fact( 0) vraća 1
IMLOG10(string)
String
IMLOG10("3+4i ") returns" 0.69897+0.402719i "
fact( 0) vraća 1
IMSQRT(string)
String
IMSQRT("1+i ") returns" 1.09868+0.45509i "
fact( 0) vraća 1
IMSQRT("1.2i ") returns" 0.774597+0.774597i "
fact( 0) vraća 1
Power
Eksponent
IMPOWER(string)
String
IMPOWER("4-i "; 2) returns" 15-8i "
fact( 0) vraća 1
IMPOWER("1.2 "; 2) returns 1.44
fact( 0) vraća 1
IMSUM(value; value;...)
AND (vrijednosti; vrijednosti;...)
IMSUM(1.2; "3.4+5i") returns "4.6+5i"
fact( 0) vraća 1
IMSUM(1.2; "1i") returns "1.2+i"
fact( 0) vraća 1
IMDIV(value; value;...)
AND (vrijednosti; vrijednosti;...)
IMDIV(1.2; "3.4+5i") returns "0.111597-0.164114i"
fact( 0) vraća 1
IMDIV("12+i ";" 12-i ") returns" 0.986207+0.16551i "
fact( 0) vraća 1
IMSUB(value; value;...)
AND (vrijednosti; vrijednosti;...)
IMSUB(1.2; "3.4+5i") returns "-2.2-5i"
fact( 0) vraća 1
IMSUB(1.2; "1i") returns "1.2-i"
fact( 0) vraća 1
IMPRODUCT(value; value;...)
AND (vrijednosti; vrijednosti;...)
IMPRODUCT(1.2; "3.4+5i") returns "4.08+6i"
fact( 0) vraća 1
IMPRODUCT(1.2; "1i") returns "+1.2i"
BIN2OCT ("1010") vraća "12"
IMCONJUGATE(complex number)
kompleksni broj
IMCONJUGATE("1.2+5i ") returns" 1.2-5i "
fact( 0) vraća 1
IMCONJUGATE("-i ") returns" i "
fact( 0) vraća 1
IMCONJUGATE("12 ") returns" 12 "
fact( 0) vraća 1
IMARGUMENT(complex number)
kompleksni broj
IMARGUMENT("1.2+5i ") returns 0.6072
fact( 0) vraća 1
IMARGUMENT("-i ") returns -1.57079633
fact( 0) vraća 1
IMARGUMENT("12 ") returns" #Div/ 0 "
fact( 0) vraća 1
IMABS(complex number)
kompleksni broj
IMABS("1.2+5i ") returns 5.1419
fact( 0) vraća 1
IMABS("-i ") returns 1
fact( 0) vraća 1
IMABS("12 ") returns 12
fact( 0) vraća 1
Floating point value
Krajnja vrijednost
DELTA(1.2; 3.4) returns 0
fact( 0) vraća 1
DELTA(3; 3) returns 1
fact( 0) vraća 1
DELTA(1; TRUE) returns 1
fact( 0) vraća 1
GESTEP(1.2; 3.4) returns 0
fact( 0) vraća 1
GESTEP(3; 3) returns 1
fact( 0) vraća 1
GESTEP(0.4; TRUE) returns 0
fact( 0) vraća 1
GESTEP(4; 3) returns 1
fact( 0) vraća 1
Financial
Financijske
Issue date
Broj
First interest
Prva kamata
Par value
Početna vrijednost
Number of payments per year
Broj ponavljanja
ACCRINT("2/ 28/ 2001 ";" 8/ 31/ 2001 ";" 5/ 1/ 2001 "; 0.1; 1000; 2; 0) returns 16,944
fact( 0) vraća 1
ACCRINTM("2/ 28/ 2001 ";" 8/ 31/ 2001 "; 0.1; 100) returns 5.0278
fact( 0) vraća 1
Cost
Cijena
AMORDEGRC( 1000; "2006-02-01"; "2006-12-31"; 10; 0; 0.1; 1) returns 228
fact( 0) vraća 1
AMORLINC( 1000; "2004-02-01"; "2004-12-31"; 10; 0; 0.1; 1) returns 91.256831
fact( 0) vraća 1
Interest rate
Kamatna stopa
Periods per year
Broj ponavljanja
COMPOUND(5000; 0.12; 4; 5) equals 9030.56
atan2( 0. 5; 1. 0) jednak je 1. 107149
CONTINUOUS(1000; 0.1; 1) equals 1105.17
atan2( 0. 5; 1. 0) jednak je 1. 107149
Maturity
Mauricijus
COUPNUM("2/ 28/ 2001 ";" 8/ 31/ 2001 "; 2; 0) returns 1
fact( 0) vraća 1
rate
datum
periods
Periodi
value
Vrijednost
start
Započni
end
Sri
type
Tip
CUMIPMT( 0.06/ 12; 5*12; 100000; 5; 12; 0) equals -3562,187023
atan2( 0. 5; 1. 0) jednak je 1. 107149
CUMPRINC( 0.06/ 12; 5*12; 100000; 5; 12; 0) equals -11904.054201
atan2( 0. 5; 1. 0) jednak je 1. 107149
Salvage
Popravi
Life
Život
DB(8000; 400; 6; 3) equals 1158.40
atan2( 0. 5; 1. 0) jednak je 1. 107149
DB(8000; 400; 6; 3; 2) equals 1783.41
fact( 0) vraća 1
Factor
Faktor
DDB(75000; 1; 60; 12; 2) returns 1721.81
fact( 0) vraća 1
Redemption
Opće Mogućnosti
DISC("2/ 28/ 2001 ";" 8/ 31/ 2001 "; 12; 14) returns 0.2841
fact( 0) vraća 1
Fractional Dollar
Razlomci
Decimal Dollar
Obitelj:
DOLLARFR(1.125; 16) returns 1.02. (1 + 2/ 16)
fact( 0) vraća 1
Present value (PV)
Trenutna vrijednost
Future value (FV)
Buduća vrijednost
DURATION(0.1; 1000; 2000) returns 7.27
fact( 0) vraća 1
Coupon
Brojanje
Yield
Promijeni veličinu...
Basis
Osnova
DURATION_ADD( "1998-01-01"; "2006-01-01"; 0.08; 0.09; 2; 1) returns 5.9937749555
fact( 0) vraća 1
Nominal interest rate
Nominalna stopa
Periods
Periodi
EFFECT(0.08; 12) equals 0.083
atan2( 0. 5; 1. 0) jednak je 1. 107149
EURO(currency)
Preferenca
EURO("DEM ") equals 1.95583
ENT( 12. 55) jednako je 12
Source currency
Sortiraj uzlazno
Target currency
Valuta
EUROCONVERT(1; "EUR"; "DEM") equals 1.95583
ENT( 12. 55) jednako je 12
Present value
Trenutna vrijednost
FV(1000; 0.08; 2) equals 1166.40
atan2( 0. 5; 1. 0) jednak je 1. 107149
FV_ANNUITY(1000; 0.05; 5) equals 5525.63
atan2( 0. 5; 1. 0) jednak je 1. 107149
INTRATE("2/ 28/ 2001 ";" 8/ 31/ 2001 "; 1000000; 2000000; 1) returns 1.98
fact( 0) vraća 1
Number of periods
Broj pokušaja
Present values
Trenutna vrijednost
Future value (optional)
Buduća vrijednost
Type (optional)
Boja teksta
Rate is the periodic interest rate.
Kamatna stopa
IPMT(0.1; 3; 3; 8000) equals -292.45
atan2( 0. 5; 1. 0) jednak je 1. 107149
Present values (PV)
Trenutna vrijednost
ISPMT(0.1; 1; 3; 8000000) equals -533333
atan2( 0. 5; 1. 0) jednak je 1. 107149
Face value
Buduća vrijednost
Coupon rate
Broj ponavljanja
Coupons per year
Broj ponavljanja
Market interest rate
Kamatna stopa
LEVEL_COUPON(1000; .13; 2; 4; .1) equals 1096.95
ENT( 12. 55) jednako je 12
MDURATION("2004-02-01 ";" 2004-05-31 "; 0.08; 0.09; 2; 0) returns 0.316321106
fact( 0) vraća 1
Values
& Vrijednosti
Reinvestment
Ulaganje
Effective interest rate
Efektivna stopa
NOMINAL(0.08; 12) equals 0.0772
cos( PI/ 2) jednak je 0. 0
Future value (FV - optional)
Buduća vrijednost
NPER(0.1; -100; 1000) equals 11
atan2( 0. 5; 1. 0) jednak je 1. 107149
NPER(0.06; 0; -10000; 20000; 0) returns 11.906
atan2( 0. 5; 1. 0) jednak je 1. 107149
Values (array)
& Vrijednosti
NPV(Rate; Values)
atan2 (vrijednost; vrijednost)
Last
Popis:
AnnualYield
Promijeni veličinu...
Price
Pregled
The ODDLYIELD function calculates the yield of the security which has an irregular last interest date.
Standardno
Number of periods (NPer)
Broj pokušaja
PMT(0.1; 4; 10000) equals -3154.71
atan2( 0. 5; 1. 0) jednak je 1. 107149
PPMT(0.0875; 1; 36; 5000; 8000; 1) equals -18.48
atan2( 0. 5; 1. 0) jednak je 1. 107149
Discount rate
Broj ponavljanja
Basis Calculation method
Proračunski mod
Future value
Buduća vrijednost
PV(1166.4; 0.08; 2) equals 1000
atan2( 0. 5; 1. 0) jednak je 1. 107149
PV_ANNUITY(1000; 0.05; 5) equals 4329.48
atan2( 0. 5; 1. 0) jednak je 1. 107149
RECEIVED("2/ 28/ 2001 ";" 8/ 31/ 2001 "; 1000; 0.05; 0) returns 1,025.787
fact( 0) vraća 1
The RRI function calculates the interest rate resulting from the profit (return) of an investment.
Standardno
RRI(1; 100; 200) returns 1
fact( 0) vraća 1
SLN(10000; 700; 10) equals 930
atan2( 0. 5; 1. 0) jednak je 1. 107149
SYD(5000; 200; 5; 2) equals 1280
atan2( 0. 5; 1. 0) jednak je 1. 107149