function - if + small

[0-0 Wai Wai ^-^]

The function is as follows:
=IF(SMALL(C6:V6,2)="#NUM!","",SMALL(C6:V6,2))

Explanation
Purpose: Try to compare a series of numbers, finding out the second smallest
number.
If: The answer is error (ie #NUM!) since there is no number in the row
Then: show nothing (ie "")
Else: show the answer as usual


** Problem **
However this function doesn't work. When there is an error, it will show as
#NUM! instead of nothing (ie "").
How to solve?

Thanks.

 

[Dave Peterson]

maybe:

=IF(ISERROR(SMALL(c6:v6,2)),"",SMALL(c6:v6,2))