Forum Discussion
NUM Error
Hi! I selected non-adjacent cells to form an array and inserted it into the SMALL formula. The feedback after entering the formula was #NUM!. How do I correct this error?
If all the selected cells are blank the SMALL function returns the #NUM! error.
=IFERROR(SMALL((A3,C3,E3,G3),1),"")You can apply IFERROR in order to return a blank cell if all selected cells are blank.