NAN is an acronym for not a number. This acronym is displayed in numeric cells when the value in a cell does not evaluate to a proper number. For example, 1/0 = #NaN.
Try Predictive Systems Lab
Interactive Demo →
Need Help? Contact support