Forum Discussion
#NUM! Error
I need to see how to "fix" the #NUM! error on my spreadsheet. Once data is entered in the cells it refers to the results are correct. The formula is: =SMALL(M20:M23,COUNTIF($M$20:$M$23,0)+1)
=IFERROR(SMALL(M20:M23,COUNTIF($M$20:$M$23,0)+1),"")
- Thank you. That appears to have fixed it.
