=IF( OR(C4="Exeter",C4="Paignton",C4="Barnstaple",C4="Taunton",C4="Bridgwater",C4="Poole"),IF(D4>=10,"Alert",""),"")
managed to get a little be further, but now stuck on the last bit