Ninja Tables supports various Excel formulas to manipulate data directly within the table. Below is a list of supported Excel formulas along with examples of how to use them in Ninja Tables.
For a comprehensive list of supported Excel formulas, please refer to Screenshot link.
Formula: IF
Description: Returns one value if a condition is true and another value if it's false.
Example:
=IF('{{row.ninja_tables_column_key}}'='',"Empty","NOT Empty")
Explanation: This formula checks if the specified column value is empty. If it's empty, it returns "Empty"; otherwise, it returns "NOT Empty".
- Here is an example of where to find the refence shortcode: Screenshot link.
- Wrap column values with single or double quotation
'{{row.ninja_tables_column_key}}'or"{{row.ninja_tables_column_key}}"to reference them in formulas. - Pay attention to quotation marks single or double (' or ") when writing formulas. Sometimes they are required, and sometimes they are not, depending on the context.
- As shown in the example above, you can wrap HTML tags in double quotation marks or single quotation marks.
By following these guidelines and examples, you can effectively utilize Excel formulas within Ninja Tables to perform various data manipulations.