na
Use NA (Not Available) in an IF-THEN-ELSE function to test for missing results. Missing results occur if there are no values to calculate.
Syntax
Example:
IF ([120]/[121]) = NA then 0 else ([120]/[121])
First the function tests whether [120]/[121] is NA. If so the value "0" is returned, otherwise the result of the function is returned in the usual way.
How to create
Click the NA button in the calculator, e.g. to add a test for missing values to an IF-THEN-ELSE function.
Calculations with NA and NaN
Some examples of calculations using NA and NaN
|
Function |
Result |
|
NA+NA |
NA |
|
NA/NA |
NA |
|
5/NA |
NA |
|
NA/5 |
NA |
|
5+NA |
5 |
|
5+(NA+NA) |
5 |
|
5+(NA/NA) |
5 |
|
NaN+NA |
NaN |
|
NaN-NA |
NaN |
|
NaN*NA |
NA |
|
NaN/NA |
NA |
Anything divided by NA is NA.
Any number or variable divided by 0 will give NaN, e.g. NA/0, 1/0 or x/0 will all give NaN.
