#NUM!
 

If have the following in cells C21 thru' C25 on a
worksheet

=SMALL(Medal!F$5:F$50,1)
=SMALL(Medal!F$5:F$50,2)
=SMALL(Medal!F$5:F$50,3)
=SMALL(Medal!F$5:F$50,4)
=SMALL(Medal!F$5:F$50,5)

Prior to any entries appearing in the Medal worksheet,
C21 thru'C25 contain #NUM!. I don't want these to be
shown. What addition to the code above needs to be made
such that the cells will initially appear blank

#NUM!
 

Hi
use something like
=IF(ISERROR(SMALL(Medal!F$5:F$50,1)),"",SMALL(Meda l!F$5:F$50,1))



--
Regards
Frank Kabel
Frankfurt, Germany


TomD wrote:
If have the following in cells C21 thru' C25 on a
worksheet

=SMALL(Medal!F$5:F$50,1)
=SMALL(Medal!F$5:F$50,2)
=SMALL(Medal!F$5:F$50,3)
=SMALL(Medal!F$5:F$50,4)
=SMALL(Medal!F$5:F$50,5)

Prior to any entries appearing in the Medal worksheet,
C21 thru'C25 contain #NUM!. I don't want these to be
shown. What addition to the code above needs to be made
such that the cells will initially appear blank

#NUM!
 

Frank,

Thanks. Works as required.

Tom
-----Original Message-----
Hi
use something like
=IF(ISERROR(SMALL(Medal!F$5:F$50,1)),"",SMALL(Med al!
F$5:F$50,1))



--
Regards
Frank Kabel
Frankfurt, Germany


TomD wrote:
If have the following in cells C21 thru' C25 on a
worksheet

=SMALL(Medal!F$5:F$50,1)
=SMALL(Medal!F$5:F$50,2)
=SMALL(Medal!F$5:F$50,3)
=SMALL(Medal!F$5:F$50,4)
=SMALL(Medal!F$5:F$50,5)

Prior to any entries appearing in the Medal worksheet,
C21 thru'C25 contain #NUM!. I don't want these to be
shown. What addition to the code above needs to be
made
such that the cells will initially appear blank
.