=IF(ISNUMBER(SEARCH(“造价”, B2)), 1234, IF(ISNUMBER(SEARCH(“监理”, B2)), 2333, “”))
=IF(ISNUMBER(SEARCH(“造价”, B2)), “1234”, “”)
=IF(ISNUMBER(SEARCH(“造价”, B2)), 1234, IF(ISNUMBER(SEARCH(“监理”, B2)), 2333, “”))
=IF(ISNUMBER(SEARCH(“造价”, B2)), “1234”, “”)