if there is some nan in the dataframe returned by an array UDF, all values in Excel are set to #VALUE!
if there is some nan in the dataframe returned by an array UDF, all values in Excel are set to #VALUE!