Function Reference: NA
| Syntax | ||
| =NA() | ||
| Purpose / Description | ||
| Returns the error value #N/A. | ||
| Arguments | ||
| Name | Type | Description |
| none | ||
| Return Values | ||
| Type | Specific Value | Description |
| error | #N/A | This function's sole purpose is to return the value #N/A. |
| Notes / Comments / Advice / Warnings | ||
| Comment: | Useful in some charting exercises, as in standard charts, #N/A is treated as if the cell is blank, so provides a way for a formula to signal to the chart that no value should be plotted. See examples in our courses and online tutorials that demonstrate this behaviour. | |