Remove #VALUE! and display a clean cell

hi there

i have a formula:
=TRIM(IF(COUNTIF(Teams!B7:B17,A5),Teams!B5,"")&" "&IF(COUNTIF(Teams!C7:C17,A5),Teams!C5,"")&" "&IF(COUNTIF(Teams!D7:D17,A5),Teams!D5,"")&" "&IF(COUNTIF(Teams!E7:E17,A5),Teams!E5,"")&" "&IF(COUNTIF(Teams!F7:F17,A5),Teams!F5,""))*1

when the time or name is not there it shows #VALUE!, this is because of the *1 at the end of the formule, all i want is for #VALUE! to be gone and only display a clear cell until both time and name is entered!

Thank you / Kind Regards

Jonathan Van Rooyen