The comma separated values (CSV) data for spreadsheet: me

,The Num Sum formula language,,,Sample Data,10,, ,supports functions and,,,,30,, ,mathematical operators,,,,50,, ,,,,,,, ,Function Name,Example,Result,,,, ,SUM,"=SUM(F2:F4)",90,,,, ,AVERAGE,"=AVERAGE(F2:F4)",30,,,, ,COUNT,"=COUNT(F2:F4)",3,,,, ,MIN,"=MIN(F2:F4)",10,,,, ,MAX,"=MAX(F2:F4)",50,,,, ,ABS,"=ABS(F3-F4)",20,,,, ,CEILING,"=CEILING(F2/F3)",1,,,, ,FLOOR,"=FLOOR(F2/F3)",,,,, ,ROUND,"=ROUND(1.6)",2,,,, ,RAND,"=RAND()",0.27297660365795184,,,, ,TRUE,"=TRUE() || FALSE()",true,,,, ,FALSE,"=TRUE() && FALSE()",,,,, ,FIXED,"=FIXED(1234.2345)",1\,234.23,,,, ,,"=FIXED(1234.2345\, 3)",1\,234.235,2nd argument is number of decimal places,,, ,DOLLAR,"=DOLLAR(123.456)",$123.46,Converts a number into a US currency string,,, ,N,"=N(D21)",123.46,N converts a value into a number,,, ,,,,,,, ,a * b (multiply),"=F2*F3*F4",15000,,,, ,a / b (divide),"=F2/F3/F4",0.006666666666666666,,,, ,a + b (add),"=F2+F3+F4",90,,,, ,a - b (subtract),"=F2-F3",-20,,,, ,a % b (modulo or remainder),"=F2 % F3",10,,,, ,a < b (less than test),"=F2<100",true,,,, ,a <= b (less than or equal to test),"=100<=F3",,,,, ,a == b (equal to test),"=F2==F3-20",true,,,, ,a != b (inequality test),"=F2!=F3",true,,,, ,a > b (greater than test),"=F2>F3",,,,, ,a >= b (greater than or equal to test),"=F2>=F3",,,,, ,!a (boolean not),"=!(F2 < 5)",true,,,, ,a ? b : c (boolean if expression),"=F2 == 10 ? F3 : F4",30,,,, ,(a + b) / c (parentheses for expression precedence),"=(F2 + F3) / F4",0.8,,,,

You can also export the spreadsheet's formulas instead of its calculated data.

Go back to spreadsheet: me.