Glad to help. You will note that this still allows a REAL zero.

--
Don Guillett
SalesAid Software

"Keith (Southend)" wrote in message
...
Don Guillett wrote:
You could use
=IF(COUNT(A1,D1,T1)=0,"",MIN(A1,D1,T1))

Yes, that does the job superbly.
I can add "-" or "x" and that's what it returns. :-)
I can also have as many or as few cells in the combinations. :-)
Change MIN to MAX where required.
This is great.

Many thanks again, much appreciated :-)

--
Keith (Southend)
http://www.southendweather.net
e-mail: kreh at southendweather dot net