I recently learned there is such a thing as ISNA for recognising #N/A (since
using IF(C1="#N/A",... didn't work unless I copied the #N/A from the C1
position...weird...)

Is there such a function for #NUM??? ISNU and ISNUM don't seem to work.