Home
Analogues
This section contains 1010data analogues for Excel and SQL users.
1010data for Excel users
1010data can solve the same problems that you are used to solving in Excel in one or more ways. Sometimes there are direct translations between the two, and sometimes a unique solution is needed in order to arrive at the same result.
Function comparisons
You know how to use certain functions in Excel, but you want to know how to complete the same tasks using 1010data's functions. While some Excel functions have a direct match to a function in 1010data, others match to a combination of functions/operations. The following sections show some of the analogous functions between Excel and 1010data.
Logical Functions

Logical Functions


Excel Function	1010data Function	Description
`IF(logical_test, value_if_true, value_if_false)`	`if(C1;R1;C2;R2;...;D)`	Returns the value corresponding to the first condition that evaluates to true; if no conditions are true, returns the specified default value.
`IFNA(value, value_if_na )`	`ifnull(X;Y)`	Returns a specified value when the value in a given column is N/A.
`AND(logical_test1, [logical_test2], ...)`	`g_and(G;S;X)`	For Excel, it returns `TRUE` if all given conditions are true for a specified value or `FALSE`otherwise. For 1010data, it returns a boolean value indicating whether all values within a given group are true.
`OR( logical_test1, [logical_test2], ...)`	`g_or(G;S;X)`	For Excel, it returns `TRUE` if any one of a set given conditions is true for a specified value or `FALSE`none are true. FOr 1010data, it returns a boolean value indicating whether any value within a given group is true.