9 Can't insert a new column if the last column is not empty.
10 Can't insert a new row if the last row is not empty.
11 Do you want the respective records to be deleted together with spreadsheet rows?\n(This action can not be undone.)
12 Valid page numbers are between 1 and 9182.
13 Failed to create object. Make sure the object is entered in the system registry.
14 Invalid row or column range.
15 Invalid password.
16 Invalid number.
17 OLE initialization failed. Make sure that the OLE libraries are the correct version.
18 Invalid password.
19 Invalid file format.
20 Selected data range is too big.
21 Constants can not be negative numbers.
22 Solution not found.
23 The database does not exist. This database format must use an existing file.
24 Save Text File
27 Black
28 Maroon
29 Green
30 Olive
31 Navy
32 Purple
33 Teal
34 Gray
35 Silver
36 Red
37 Lime
38 Yellow
39 Blue
40 Fuchsia
41 Aqua
42 White
43 Automatic
44 New
45 Chart
46 Properties
47 Ellipse
48 Rectangle
49 Selected object is too big.
50 Save Database
51 Open Database
100 Server is still busy.
106 Integration
32796 Insert a new chart.\nChart
32797 Sorts selected cells.\nSort
32798 Changes font for the current selection.\nFont Name
32799 Changes font size for the current selection.\nFont Size
32800 Inserts a new column.
32801 Removes columns from the active document.
32802 Inserts a new row.
32803 Removes rows from the active document.
32804 Sets or removes cells protection.
32806 Aligns text to the left side of a cell.\nLeft
32807 Aligns text to the right side of a cell.\nRight
32808 Centers text horizontally.\nCenter Horizontally
32810 Displays numbers as a currency.\nCurrency
32811 Displays numbers with the percent sign.\nPercent
32812 Displays numbers with separators.\nSeparator in Numbers
32814 Sets or removes bold format.\nBold (Ctrl+B)
32815 Sets or removes Italic format.\nItalic (Ctrl+I)
32816 Sets or removes underline format.\nUnderline (Ctrl+U)
32823 Changes the page options.\nPage Setup
32831 Recalculates all formulas of the active document.
32832 Sets or removes strikeout format.\nStrikeout
32833 Selects normal format.\nNormal
32834 Sets the default style of displaying numbers.
32835 Enables you to select frames for the current selection.\nFrame
32837 Removes frames.
32838 Enables you to change cell and font colors.\nColors
32839 Sets the default row heights.
32850 Inserts a new ellipse.\nEllipse
32851 Inserts a new rectangle.\nRectangle
32855 Hides or shows the selected cells.
32858 Sets or removes breaking text.
32859 Removes cell and font colors.
32861 Enables you to change font shadow.\nShadow
32864 Removes font shadow.
32869 Moves the selected object to foreground.
32870 Moves the selected object to background.
32874 &Update Records
32875 Removes frames.
32876 Solves a linear equation system.
32877 Finds an optimal solution using linear programming.
32878 Inverses matrix.
32882 Calculates the determinant of a square matrix.
32883 Performs Interpolation.
32884 Performs Integration.
32885 Calculates correlation.
32888 Pastes selected formula.
32890 Enables you to change the number of displayed decimal digits.\nDecimal Places
32892 Enables you to change the password.
32895 Enables you to change the program settings.
32900 Displays and changes information about the current document.
32901 Inserts series of numbers or text.
32903 Shows or hides the Formatting toolbar.
32905 Changes the current displaying scale.\nZoom
32906 Shows or hides the grid.
32907 Inserts series of numbers or text.
32908 Aligns text to the upper cell edge.
32909 Aligns text to the down cell edge.
32910 Centers text vertically.
32966 Edits object properties.
32967 View or edit the settings of the selected cells.
32968 Insert selected formula.
32969 Removes formatting for the selected cells.
32970 Changes width or height of the selected columns or rows.
32971 Replaces all formulas within the selected cells by their values.
57344 GS-Calc
57345 For Help, press F1
57346
57347 %1 in %2
57349 %1 - %2
57600 Creates a new document.\nNew (Ctrl+N)
57601 Opens an existing document.\nOpen (Ctrl+O)
57602 Closes the active document.\nClose
57603 Saves the active document.\nSave (Ctrl+S)
57604 Saves the active document with a new name.\nSave As
57605 Changes page layout.
57606 Changes the printer and printing options.\nPrint Setup
57607 Prints the active document.\nPrint (Ctrl+P)
57609 Displays full pages.\nPrint Preview
57610 Updates the container to show any changes.\nUpdate
57611 Save a copy of the active document with a new name.\nSave Copy
57612 Sends the active document through electronic mail.\nSend Mail
57616 Opens this document.
57617 Opens this document.
57618 Opens this document.
57619 Opens this document.
57632 Cuts the selection.\nDel (Del)
57634 Copies the selection and puts it on the Clipboard.\nCopy (Ctrl+C)
57635 Cuts the selection and puts it on the Clipboard.\nCut (Ctrl+X)
57636 Searches the current document for text.\nFind (Ctrl+F)
57637 Inserts Clipboard contents.\nPaste (Ctrl+V)
57638 Inserts Clipboard contents with link.\nPaste Link
57639 Inserts Clipboard contents with options.\nPaste Special
57640 Repeats the last action.\nRepeat (Ctrl+R)
57641 Searches the current document for text and replaces it.\nReplace (Ctrl+H)
57643 Undoes the last action.\nUndo (Ctrl+Z)
57644 Redoes the undone action.\nRedo (Ctrl+A)
57648 Opens another window for the active document.\nNew Window
57649 Arranges icons at the bottom of the window.\nArrange Icons
57650 Arranges windows so they overlap.\nCascade Windows
57651 Arranges windows as non-overlapping tiles.
57652 Arranges windows as non-overlapping tiles.
57653 Splits the active window into four panes.
57664 Displays program information, version number and copyright.\nAbout
57665 Quits the application; prompts to save documents.\nExit
57667 Lists Help topics.\nHelp Topics
57669 Displays help for clicked on buttons, menus and windows.\nHelp
57670
57680
57681
57696 Enables you to change font name, size and style.\nFont
57856 Inserts a new embedded object.\nNew Object
57857 Edits linked objects.\nEdit Links
57872 Activates embedded or linked object.
57873 Activates embedded or linked object.
57874 Activates embedded or linked object.
57875 Activates embedded or linked object.
59136 EXT
59137 CAPS
59138 NUM
59139 SCRL
59140 OVR
59141 REC
59392 Shows or hides the Standard toolbar.
59393 Shows or hides the status bar.
61184 Changes the window size.
61185 Changes the window position.
61186 Reduces the window to an icon.
61187 Enlarges the window to full size.
61188 Switches to the next document window.
61189 Switches to the previous document window.
61190 Switches to the previous document window.
61202 Restores the window to normal size.
61203 Activates Task List.
61215 Activates this window.
61221 ABS\nABS(Number)\n\nReturns the absolute value of Number.\nExample: ABS(-10) = 10
61222 SGN\nSGN(Number)\n\nReturns -1 if Number < 0, 0 if Number = 0 and 1 if Number > 0.\nExample: SGN(10) = 1
61223 AND\nAND(Number1; Number2)\n\nReturns the bitwise AND of Number1 and Number2.\nExample: AND(12; 4) = 4
61224 NOT\nNOT(Number)\n\nReturns the bitwise negation of Number.\nExample: NOT(10) = -11
61225 OR\nOR(Number1; Number2)\n\nReturns the bitwise OR of Number1 and Number2.\nExample: OR(8; 4) = 12
61226 XOR\nXOR(Number1; Number2)\n\nReturns the bitwise XOR of Number1 and Number2.\nExample: XOR(12; 4) = 8
61227 ARCOSH\nARCOSH(Number)\n\nReturns the inverse hyperbolic cosine of Number.\nExample: ARCOSH(1.5) = 0.96242365
61228 ARSINH\nARSINH(Number)\n\nReturns the inverse hyperbolic sine of Number.\nExample: ARSINH(1.5) = 1.19476322
61229 ARTGH\nARTGH(Number)\n\nReturns the inverse hyperbolic tangent of Number.\nExample: ATGH(0.5) = 0.54930614
61230 COSECH\nCOSECH(Number)\n\nReturns the hyperbolic cosecant of Number.\nExample: COSECH(1.5) = 0.46964244
61231 COSH\nCOSH(Number)\n\nReturns the hyperbolic cosine of Number.\nExample: COSH(1.5) = 2.35240962
61232 SECH\nSECH(Number)\n\nReturns the hyperbolic secant of Number.\nExample: SECH(1.5) = 0.42509603
61233 SINH\nSINH(Number)\n\nReturns the hyperbolic sine of Number.\nExample: SINH(1.5) = 2.12927946
61234 TANH\nTANH(Number)\n\nReturns the hyperbolic tangent of Number.\nExample: TANH(1.5) = 0.90514825
61235 ACOS\nACOS(Number)\n\nReturns the arccosine of Number.\nExample: ACOS(0.5) = 1.04719755 (=PI/3)
61236 ASIN\nASIN(Number)\n\nReturns the arcsine of Number.\nExample: ASIN(0.5) = 0.52359878 (=PI/6)
61237 ATAN\nATAN(Number)\n\nReturns the arctangent of Number.\nExample: ATAN(1) = 0.78539816 (PI/4)
61238 COS\nCOS(Number)\n\nReturns the cosine of Number.\nExample: COS(PI(1)/3) = 0.5
61239 SIN\nSIN(Number)\n\nReturns the sine of Number.\nExample: SIN(PI(1)/6) = 0.5
61240 TAN\nTAN(Number)\n\nReturns the tangent of Number.\nExample: TAN(PI(1)/4) = 1
61241 BJ0\nBJ0(Number)\n\nReturns the value of the Bessel function of the first kind and zero level for Number.\nExample: BJ0(0.9) = 0.8075238
61242 BJ1\nBJ1(Number)\n\nReturns the value of the Bessel function of the first kind and second level for Number.\nExample: BJ1(0.9) = 0.40594955
61243 BJN\nBJN(Level; Number)\n\nReturns the value of the Bessel function of the first kind for the given Level and Number.\nExample: BJN(1;0.9) = 0.40594955
61244 BY0\nBY0(Number)\n\nReturns the value of the Bessel function of the second kind and zero level for Number.\nExample: BY0(0.9) = 0.00562831
61245 BY1\nBY1(Number)\n\nReturns the value of the Bessel function of the second kind and first level for Number.\nExample: BY1(0.9) = -0.87312658
61246 BYN\nBYN(Level; Number)\n\nReturns the value of the Bessel function of the second kind for the given Level and Number.\nExample: BY1(1; 0.9) = -0.87312658
61247 DEGREES\nDEGREES(Number)\n\nConverts Number, which represents an angle in radians, to degrees.\nExample: DEGREES(PI(1)/4) = 45
61248 RADIANS\nRADIANS(Number)\n\nConverts Number, which represents an angle in degrees, to radians.\nExample: RADIANS(45) = 0.78539816 (=PI(1)/4)
61249 EXPM\nEXPM(Number)\n\nReturns the mantissa m of Number (m is greater than or equal to 0.5 and less than 1) so that Number = m*2^k, where k is the exponent.\nExample: EXPM(1.5) = 0.75
61250 EXPE\nEXPE(Number)\n\nReturns the exponent k of Number so that Number = m*2^k, where m is the mantissa.\nExample: EXPE(1.5) = 1
61251 EXP\nEXP(Number)\n\nReturns the base of the natural logarithm ("e") raised to the power of Number.\nExample: EXP(2) = 7.3890561
61252 FACT\nFACT(Number)\n\nReturns the factorial of Number: the product of all integers greater than zero and not greater than Number.\nExample: FACT(5) = 120
61253 GCD\nGCD(Number1; Number2)\n\nReturns the greatest common divisor of Number1 and Number2.\nExample: GCD(24;16) = 8
61254 SCM\nSCM(Number1; Number2)\n\nReturns the smallest common multiplicity of Number1 and Number2.\nExample: SCM(12; 8) = 24
61255 LOG10\nLOG10(Number)\n\nReturns the base 10 logarithm of Number.\nExample: LOG10(100) = 2
61256 LOG\nLOG(Number)\n\nReturns the natural logarithm of Number.\nExample: LOG(EXP(2)) = 2
61257 LOGX\nLOGX(Number; Base)\n\nReturns the Base logarithm of Number.\nExample: LOGX(2^5; 2) = 5
61258 MOD\nMOD(Number1; Number2)\n\nReturns the reminder of Number1 / Number2.\nExample: MOD(9; 4) = 1
61259 POW10\nPOW10(Number)\n\nReturns 10 to the power of Number.\nExample: POW10(2) = 100
61260 PI\nPI(Number)\n\nReturns the product of Number and the value PI (3.141592653589).\nExample: PI(1) = 6.2831853
61261 CEIL\nCEIL(Number)\n\nReturns a number representing the smallest integer greater than or equal to Number.\nExample: CEIL(2.6) = 3
61262 ROUND\nROUND(Number)\n\nReturns Number rounded to the nearest integer.\nExample: ROUND(2.4) = 2
61263 ROUNDE\nROUNDE(Number)\n\nReturns Number rounded to the nearest even number.\nExample: ROUNDE(3.1) = 4
61264 EVEN\nEVEN(Number)\n\nReturns Number rounded to the nearest even number.\nExample: EVEN(3.1) = 4
61265 ROUNDO\nROUNDO(Number)\n\nReturns Number rounded to the nearest odd number.\nExample: ROUNDO(2.1) = 3
61266 ODD\nODD(Number)\n\nReturns Number rounded to the nearest odd number.\nExample: ODD(2.1) = 3
61267 ROUNDX\nROUNDX(Number; Precision)\n\nReturns Number rounded to the factor specified by Precision.\nExample: ROUNDX(2.1; 0.5) = 2.5
61268 TRUNC\nTRUNC(Number)\n\nReturns the integer portion of Number.\nExample: TRUNC(2.5) = 2
61269 SHIFTL\nSHIFTL(Number; Positions)\n\nReturns the value of Number after shifting its bits by Positions to the left.\nExample: SHIFTL(2; 3) = 16
61270 SHIFTR\nSHIFTR(Number; Positions)\n\nReturns the value of Number after shifting its bits by Positions to the right.\nExample: SHIFTR(16; 3) = 2
61271 SQR\nSQR(Number)\n\nReturns the square of Number.\nExample:SQR(3) = 9
61272 SQRT\nSQRT(Number)\n\nReturns the square root of Number.\nExample: SQRT(9) = 3
61273 INTERPOL\nINTERPOL(X_range; Y_range; Point)\n\nPerforms interpolation of a function in Point based on points from X_range and function values from Y_range.\nExample: INTERPOL(A1:A10; B1:B10; 3) = 2.3
61274 COMBNR\nCOMBNR(n;k)\n\nReturns the number of k-element combinations with repeating from the n-element set.\nExample: COMBNR(5; 3) = 35
61275 COMBNS\nCOMBNS(n; k)\n\nReturns the number of k-element combinations without repeating from the n-element set.\nExample: COMBNS(5; 3) = 10
61276 GRANDTOTAL\nGRANDTOTAL(Range)\n\nReturns the sum of values of formulas containing the SUBTOTAL function in the given range.\nExample: GRANDTOTAL(A1:B10) = 12
61277 SUBTOTAL\nSUBTOTAL(Range)\n\nReturns the sum of numbers from the given range.\nExample: SUBTOTAL(A1:B10) = 12
61278 MAX\nMAX(Range)\n\nReturns the largest number in the given range.\nExample: MAX(A1:B10) = 5
61279 MIN\nMIN(Range)\n\nReturns the smallest number in the given range.\nExample: MIN(A1:B10)
61280 RAND\nRAND(Number)\n\nReturns a random number greater or equal to 0 and less or equal to Number.\nExample: RAND(60) = 34.56
61281 SUM\nSUM(Range)\n\nReturns the sum of numbers from the given range.\nExample: SUM(A1:B10)
61282 SUM2\nSUM2(Range)\n\nReturns the sum of squares of numbers from the given range.\nExample: SUM2(A1:B10)
61283 SUM3\nSUM3(Range)\n\nReturns the sum of cubes of numbers from the given range.\nExample: SUM3(A1:B10)
61284 PRODUCTIF\nPRODUCTIF(Value1; Value2; ConditionsRange; InputRange)\n\nReturns the product of numbers from InputRange.\nExample: PRODUCTIF(10248; 10252; A2:A7; C2:C7)
61285 SUMIF\nSUMIF(Value1; Value2; ConditionsRange; InputRange)\n\nReturns the sum of numbers from InputRange.\nExample: SUMIF(10248; 10252; A2:A7; C2:C7)
61286 SUM2IF\nSUMIF2(Value1; Value2; ConditionsRange; InputRange)\n\nReturns the sum of squares of numbers from InputRange.\nExample: SUM2IF(10248; 10252; A2:A7; C2:C7)
61287 SUM3IF\nSUMIF3(Value1; Value2; ConditionsRange; InputRange)\n\nReturns the sum of cubes of numbers from InputRange.\nExample: SUM2IF(10248; 10252; A2:A7; C2:C7)
61288
61289
61290 AREA\nAREA(Range)\n\nReturns the number of cells in Range.\nExample: AREA(A1:B10)
61291 AVE\nAVE(Range)\n\nReturns the arithmetic mean for cells in Range.\nExampe: AVE(A1:B10) = 1.1
61292 AVE2\nAVE2(Range)\n\nReturns the square mean for cells in Range.\nExample: AVE2(A1:B10) = 1.1
61293 AVEG\nAVEG(Range)\n\nReturns the geometric mean for cells in Range.\nExample: AVEG(A1:B10) = 1.1
61294 AVEH\nAVEH(Range)\n\nReturns the harmonic mean for cells in Range.\nExample: AVEH(A1:B10) = 1.1
61295 CHI2\nCHI2(Degree; Chi2Expression)\n\nReturns the confidence level for Chi2Expression, which has the chi-square distribution.\nExample: CHI2(4; 1.1) = 0.89427221
61296 STD\nSTD(Degree; TExpression)\n\nReturns the confidence level for TExpression, which has the Student distribution.\nExample: STD(4; 1.1) = 0.33308365
61297 CORREL\nCORREL(Range1; Range2)\n\nReturns the correlation between numbers from Range1 and Range2.\nExample: CORREL(A1:A10; B1:B10) = 0.9
61298 ENTROPY\nENTROPY(Range)\n\nReturns the entropy of an information source based on probability factors from the given range.\nExample: ENTROPY(A1:A2) = 1
61299 ERF\nERF(Number)\n\nReturns the integral of the Gauss function in the range {-Number*sqrt(2), Number*sqrt(2)}.\nExample: ERF(1.5) = 0.96610809
61300 ERFV\nERFV(Number)\n\nReturns the argument for which the ERF function returns Number.\nExample: ERFV(0.96610809) = 1.5
61301 EST\nEST(Range)\n\nReturns the standard deviation of a sample from the given range.\nExample: EST(A1:B10) = 1.1
61302 ESTN\nESTN(Range)\n\nReturns the standard deviation of a population.\nExample: ESTN(A1:B10) = 1.1
61303
61304
61305 CHAR\nCHAR(Number)\n\nReturns a text string consisting of one character with the character set code equal to Number.\nExample: CHAR(65) = "A"
61306 CODE\nCODE(Text)\n\nReturns the character set code of the first character in Text.\nExample: CODE("Word") = 87
61307 HEX\n\nHEX(Number)\nReturns the text string representing Number in the hex notation.\nExample: HEX(1998) = "7ce"
61308 OCT\nOCT(Number)\n\nReturns the text string representing Number in the octal notation.\nExample: OCT(1998) = "3716"
61309 TEXT\nTEXT(Number)\n\nReturns the text string representing Number in textual ("verbal") form.\nExample: TEXT(23) = "twenty three"
61310 EXACT\nEXACT(Text1; Text2)\n\nCompares two text strings. If Text1 = Text2, 1 (True) is returned. If they are different, 0 (False) is returned. The comparison is case-sensitive.\nExample: EXACT("Thing"; "Thing") = 1\n
61311 FIND\nFIND(Text1; Text2; Position)\n\nReturns the position (as a 1-base index) of Text1 in Text2. Searching starts in Text2 from Position.\nExample: FIND("word"; "two words"; 1) = 5
61312 LEFT\nLEFT(Text; Number)\n\nReturns the first Number characters from Text.\nExample: LEFT("abcdef"; 3) = "abc"
61313 LENGTH\nLENGTH(Text)\n\nReturns the length of Text.\nExample: LENGTH("abcdef") = 6
61314 LOWER\nLOWER(Text)\n\nConverts all letters in Text to lowercase.\nExample: LOWER("ABCDEF") = "abcdef"
61315 REPLACE\nREPLACE(Text1; Number1; Number2; Text2)\n\nReplaces Number2 characters in Text1 starting from Number1 position by Text2. For the first character in Text1 Number1 = 1.\nExample: REPLACE("abcdef"; 3; 2; "x") = "abxef"
61316 STEXT\nSTEXT(Text)\n\nConverts all letters in Text to lowercase.\nExample: STEXT("ABCDEF") = "abcdef"
61317 MID\nMID(Text; StartPosition; EndPosition)\n\nReturns the substring of Text. The substring starts at StartPosition and includes all characters up to EndPosition. The position of the first character in Text is 1.\nExample: MID("abcdef"; 3; 4) = "cd"\n
61318 PROPER\nPROPER(Text)\n\nConverts first letters of words in Text to uppercase and all other letters to lowercase.\nExample: PROPER("two WORDS") = "Two Words"
61319 REPEAT\nREPEAT(Text; Number)\n\nReturns string that consists of Text repeated Number times.\nExample: REPEAT("abc "; 3) = "abc abc abc "
61320 RIGHT\nRIGHT(Text; Number)\n\nReturns the last Number characters from Text.\nExample: RIGHT("abcdef"; 3) = "def"
61321 TRIM\nTRIM(Text)\n\nRemoves all trailing and leading whitespaces from Text.\nExample: TRIM(" abcdef ") = "abcdef"
61322 LTRIM\nLTRIM(Text)\n\nRemoves all leading whitespaces from Text.\nExample: LTRIM(" abcdef") = "abcdef"
61323 RTRIM\nRTRIM(Text)\n\nRemoves all trailing whitespaces from Text.\nExample: RTRIM("abcdef ") = "abcdef"
61324 UPPER\nUPPER(Text)\n\nConverts all letters in Text to uppercase.\nExample: UPPER("abcdef") = "ABCDEF"
61325 ETEXT\nETEXT(Text)\n\nConverts all letters in Text to uppercase.\nExample: ETEXT("abcdef") = "ABCDEF"
61326 TRAIL\nTRAIL(Text; Number)\n\nIf Text length is less than Number, this function adds trailing spaces to Text so that Text contains exactly of Number characters.\nExample: TRAIL("abc", 6) = "abc "\n
61327 VALUE\nVALUE(Text)\n\nConverts Text to number.\nExample: VALUE("123") = 123
61328 NUM2STR\nNUM2STR(Number; Radix)\n\nReturns the text string representing Number in the Radix notation.\nExample: NUM2STR(1998; 10) = "1998"
61329 MERGE\nMERGE(Text1; Text2)\n\nReturns the text string consisting of merged Text1 and Text2.\nExample: MERGE("abc"; "def") = "abcdef"
61330
61331
61332 CTERM\nCTERM(Rate; Fv; Pv)\n\nReturns the number of compounding periods after which the initial amount (Pv) will obtain the value specified by Fv at the given interest rate Rate.\nExample: CTERM(9%/12; 10000; 5000) = 92.76576606
61333 FVAL\nFVAL(Pv; Rate; Periods)\n\nReturns the future value of an investment or loan Pv (with no periodic payments) at the given interest rate and the given number of periods.\nExample: FVAL(5000; 9%/12; 93) = 10017.52
61334 FV\nFV(Payment; Rate; Periods)\n\nReturns the future value of an investment (with periodic payments) after the given number of periods and with the given interest rate.\nExample: FV(500; 9%/12; 24) = 13094.24
61335 PMT\nPMT(Pv; Rate; Periods)\n\nReturns the payment amount for a loan during the given number of periods.\nExample: PMT(20000; 9%/12; 24) = 913.69
61336 PV\nPV(Payment; Rate; Periods)\n\nReturns the present value for a loan or investment.\nExample: PV(500; 9%/12; 24) = 10944.57
61337 RATE\nRATE(Fv; Pv; Periods)\n\nReturns the periodic interest rate for a loan or investment (Pv) at the given number of periods.\nExample: RATE(10000; 5000; 48) = 0.01454533
61338 SLN\nSLN(Cost; Salvage; Life)\n\nReturns the straight-line depreciation for one period.\nExample: SLN(3000; 400; 5) = 520
61339 SYD\nSYD(Cost; Salvage; Life; Period)\n\nReturns the sum-of-the-years'-digits' depreciation for the given period.\nExample: SYD(3000; 400; 5; 4) = 346.67
61340 TERM\nTERM(Payment; Rate; Pv)\n\nReturns the number of payment periods for an investment or loan (Pv) with the given interest rate and payment.\nExample: TERM(500; 9%/12; 10000) = 18.71
61341
61342
61343 DATE\nDATE(Year; Month; Day)\n\nReturns the date/time number for the given Year, Month and Day. This integer portion represents the number of days from 30 December 1899, midnight and the fractional portion represents hours.\nExample: DATE(1998; 1; 1) = 35796
61344 TIME\nTIME(Hour; Minute; Second)\n\nReturns the date/time number for the given Year, Month and Day. This integer portion represents the number of days from 30 December 1899, midnight and the fractional portion represents hours.\nExample: TIME(11; 53; 44) = 0.49564815
61345 DATEDIF\nDATEDIF(DateNumber1; DateNumber2; Type)\n\nCalculates the difference between two dates. The result depends on Type.\nExample: DATEDIF(DATE(1998;3;1)+TIME(10;45;0); DATE(1998;1;1)+TIME(9;45;0); 6) = 85020 (minutes)
61346 DATEVALUE\nDATEVALUE(Text)\n\nReturns the date/time number for the given date formatted as Text. To be parsed correctly, the text string must conform to the currently defined in system short date/time format.\nExample: DATEVALUE("13/1/98") = 35808
61347 TIMEVALUE\nTIMEVALUE(Text)\n\nReturns the date/time number for the given time formatted as Text. To be parsed correctly, the text string must conform to the currently defined in system short date/time format.\nExample: TIMEVALUE("9:45:34 PM") = 0.90664352
61348 DAY\nDAY(DateNumber)\n\nReturns the day of the month (1-31) for the DateNumber.\nExample: DAY(DATE(1998;1;1)) = 1
61349 HOUR\nHOUR(DateNumber)\n\nReturns the hour(0-23) for the DateNumber.\nExample: HOUR(TIME(23;12;56)) = 23
61350 MINUTE\nMINUTE(DateNumber)\n\nReturns the minute (0-59) for the DateNumber.\nExample: MINUTE(TIME(23;12;56)) = 12
61351 SECOND\nSECOND(DateNumber)\n\nReturns the second (0-59) for the DateNumber.\nExample: SECOND(TIME(23;12;56)) = 56
61352 MONTH\nMONTH(DateNumber)\n\nReturns the month (1-12) for the DateNumber.\nExample: MONTH(DATE(1998;1;1)) = 1
61353 YEAR\nYEAR(DateNumber)\n\nReturns the year for the DateNumber.\nExample: YEAR(DATE(1998;1;1)) = 1998
61354 DAYOFWEEK\nDAYOFWEEK(DateNumber)\n\nReturns the day of the week (Sun = 1) for the DateNumber.\nExample: DAYOFWEEK(DATE(1998;1;1)) = 5
61355 DAYOFYEAR\nDAYOFYEAR(DateNumber)\n\nReturns the day of the year (Jan 1 = 1) for the DateNumber.\nExample: DAYOFYEAR(DATE(1998;1;1)) = 1
61356 FORMATDATE\nFORMATDATE(DateNumber; FormattingText)\n\nReturns the text representing date/time formatted according to FormattingText. If FormattingText is an empty string (""), the default Windows format for the date representation is used.
61357 FORMATTIME\nFORMATTIME(DateNumber; FormattingText)\n\nReturns the text representing date/time formatted according to FormattingText. If FormattingText is an empty string (""), the default Windows format for the date representation is used.
61358 TODAY\nTODAY(DaysNumber)\n\nReturns the current date/time number +/- DaysNumber.\nExample: TODAY(0) = "12/11/97"
61359 NOW\nNOW(HoursNumber)\n\nReturns the current date/time number +/- HoursNumber.\nExample: NOW(0) = "2:49:43 PM"
61360
61361
61362 COLS\nCOLS(Range)\n\nReturns the number of columns in Range.\nExample: COLS(A1:B10) = 2
61363 ROWS\nROWS(Range)\n\nReturns the number of rows in Range.\nExample: ROWS(A1:B10) = 10
61364 HLOOKUP\nHLOOKUP(SearchItem;SearchRange;RowIndex)\n\nSearchItem is compared against values in the first row of SearchRange. If a matching value is found, the contents of the cell from the corresponding column and the RowIndex row is returned.
61365 VLOOKUP\nVLOOKUP(SearchItem;SearchRange;ColumnIndex)\n\nSearchItem is compared against values in the first column of SearchRange. If a matching value is found, the contents of the cell from the corresponding row and the ColumnIndex column is returned.
61366 INDEX\nINDEX(Range; ColumnNumber; RowNumber)\n\nReturns the contents of the cell from Range. The cell position is relative to Range, i.e. ColumnNumber equal to 1 and RowNumber equal to 1 refers to the upper left corner of Range.\nExample: INDEX(A1:B10; 1; 1) (= A1)
61367 RANGE\nRANGE(LeftColumn; TopRow; RightColumn; BottomRow)\n\nCreates and returns the cell range specified by two columns LeftColumn, RightColumn (1-512) and two rows TopRow, BottomRow (1-8192).\nExample: RANGE(1; 1; 2; 10) (=A1:B10)
61368 MATCH\nMATCH(SearchItem; SearchRange; SearchType)\n\nSearchItem is compared against values in the given range. If found, the position of the matching value is returned. If there is no matching value, the error value is returned.\nMATCH("abc"; A2:D7; 0) = 14
61369 ADDRESS\nADDRESS(ColumnNumber; RowNumber)\n\nReturns the cell address specified as ColumnNumber (1 - 512) and RowNumber (1 - 8192).\nExample: ADDRESS(3; 4) (=C4)
61370 CELL\nCELL(FeatureType; CellAddress)\n\nReturns the chosen feature of a cell.\nExample: CELL(0; B5) = 2
61371 OFFSET\nOFFSET(Range; ColumnsNumber; RowsNumber)\n\nReturns Range shifted horizontally and/or vertically by ColumnsNumber and RowsNumber.\nExample: OFFSET(A1:B10; 1; 1) (=B2:C11)
61372 GETEXVAL\nGETEXVAL(Document; CellAddress; AutoOpen)\n\nReturns the value of the specified cell from another spreadsheet document.\nExample: GETEXVAL("d:\gscalc35\analyze.gsc"; E9; 1) = 100
61373 COUNT\nCOUNT(Range)\n\nReturns the number of not empty cells in the given range.\nExample: COUNT(A1:B10) = 4
61374 COUNTV\nCOUNTV(Value; SearchRange)\n\nReturns the number of cells containing Value in the given range. Value may represent a number or a text.\nExample: COUNTV(2.2; A1:B10) = 3
61375
61376
61377 TEST\nTEST(Number; TrueValue; FalseValue)\n\nIf Number is greater than or equal to 0, the TrueValue is returned. If Number is less than 0, FalseValue is returned.\nExample: TEST(10; "abc"; "cde") = "abc"
61378 IF\nIF(Condition; TrueValue; FalseValue)\n\nIf Condition, which may be any expression returning numbers, is different than 0, the TrueValue is returned. If Condition is equal to 0, FalseValue is returned.\nExample: IF((A1>1)*(A1<10); 1; 2) = 1
61379 ISERROR\nISERROR(Value)\n\nReturns 1 (True) if Value represents the error value or a cells range containing at least one error value. If no error is found, 0 is returned.\nExample: ISERROR(1/0) = 1
61380 ISNUMBER\nISNUMBER(Value)\n\nReturns 1 (True) if Value represents a number or a cells range containing only numbers. Otherwise 0 (False) is returned.\nExample: ISNUMBER(12) = 1
61381 ISSTRING\nISSTRING(Value)\n\nReturns 1 (True) if Value represents a text string or a cells range containing only text. Otherwise 0 (False) is returned.\nExample: ISSTRING("abc") = 1
61382 ISFILE\nISFILE(Text)\n\nReturns 1 (True) if Text represents a name of an existing file or 0 (False) otherwise.\nExample: ISFILE("d:\gscalc35\bnalyze.gsc") = 1
61383 ISOPEN\nISOPEN(Text)\n\nReturns 1 (True) if Text represents a name (full path) of the currently open spreadsheet document or 0 (False) otherwise.\nExample: ISOPEN("d:\gscalc35\analyze.gsc") = 1
61384
61385
61386 PLAYSOUND\nPLAYSOUND(Condition; SoundName; Type)\n\nIf Condition, which may be any expression returning numbers, is different than 0, this function plays sound specified as SoundName.\nExample: PLAYSOUND(ISERROR(B15); "c:\sound\theme.wav"; 1)
61387 OPENDOC\nOPENDOC(Condition; Document)\n\nIf Condition is different than 0, this function opens Document. This can be a complete file path of the given document, executable file or an Internet URL.\nExample: OPENDOC(B15 >10000; "d:\report.txt")
61388 OPENSHEET\nOPENSHEET(Condition; SheetName)\n\nIf Condition is different than 0, this function opens an existing document specified as SheetName. SheetName must contain a full path name of a given document.\nExample: OPENSHEET(B15<100; "d:\form1.gsc")
61389 MESSAGE\nMESSAGE(Condition; MessageText)\n\nIf Condition, which may be any expression returning numbers, is different than 0, this function displays a message specified as MessageText.\nExample: MESSAGE(ISERROR(B15); "Error Value in B15!")
