Forum Discussion

Niiamat's avatar
Niiamat
Copper Contributor
Jun 29, 2023

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?

 

excel
Formulas and Functions
  • OliverScheurich's avatar
    OliverScheurich
    Gold Contributor
    Jun 29, 2023

    Niiamat 

    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. 

Resources