NA
Formulas / NACreate an #N/A error.
#N/A
- No arguments
Examples
=IF(ISBLANK(NA()), "Yes", "No")NA() is a function in Sourcetable that is used to indicate that a cell is empty. It is often used in conjunction with the IF function, which can be used to return a value based on whether a cell is blank or not. For example, the following formula will return "Yes" if the cell is blank, and "No" if it is not blank.
=IF(ISNUMBER(NA()), "Valid Date", "#N/A")The NA() function can also be used to create an error message when a cell does not contain the expected information. This formula will return "Valid Date" if the cell contains a valid date, and the #N/A error if it does not.
=IF(NA()="", "Cell is empty", "Cell is not empty")The NA() function can also be used to check if a cell is empty or not. This formula will return "Cell is empty" if the cell is empty, and "Cell is not empty" if it is not.
=SUM(NA(), A2)For example, if you want to calculate the sum of two cells and return a result even if one of the cells is blank, you could use the preceding formula. This formula will return the value of cell A2 even if the cell containing the NA() function is blank.
Summary
The NA function does not take any arguments and requires empty parentheses. It is used for displaying and handling missing or undefined data values in R.
- The NA function returns the #N/A error, which means "not available" or "no value available".
- Using the NA function requires empty parentheses.
Need help with Formulas?
Frequently Asked Questions
What is the NA function?
What can I use the NA function for?
- Identify empty cells
- Highlight cells with missing information
How do I use the NA function?
value argument is the value to be tested. If the value is missing, the function returns the logical value TRUE. If the value is present and not empty, the function returns the logical value FALSE.
Work smarter
Al is here to help. Leverage the latest models to
analyze spreadsheets, enrich data, and create reports.