The comma separated values (CSV) data for spreadsheet: Copy of Excel Calculations Sample

,,,,,,, ,The Num Sum formula language supports functions and mathematical operators,,,Sample Data Used Below:,10,, ,,,,,30,, ,,,,,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)",0,,,, ,ROUND,"=ROUND(1.6)",2,,,, ,RAND,"=RAND()",0.8615162774438398,,,, ,TRUE,"=TRUE() || FALSE()",true,,,, ,FALSE,"=TRUE() && FALSE()",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",false,,,, ,a == b (equal to test),"=F2==F3-20",true,,,, ,a != b (inequality test),"=F2!=F3",true,,,, ,a > b (greater than test),"=F2>F3",false,,,, ,a >= b (greater than or equal to test),"=F2>=F3",false,,,, ,!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,,,, ,,,,,,, ,,,,,,, ,,,,,,, ,(This page was created as a Num Sum spreadsheet and published/exported as a HTML page.),,,,,, ,,,,,,,

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

Go back to spreadsheet: Copy of Excel Calculations Sample.