基于相邻单元格中现有值的条件Excel公式？

So I have an excel sheet. I want ColD to contain a formula that, when ColC to the left contains an "@" symbol, ColD will fill with a certain text. It would exclude Row1 as that contains headers.So I have an excel sheet. I want ColD to contai