function - if + small

  • Thread starter Thread starter 0-0 Wai Wai ^-^
  • Start date Start date
0

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.
 
Back
Top