#NUM error can occur when the data type entered is not supported in the argument of the formula. Click here to learn about #NUM error in Excel!