发布网友 发布时间:2022-04-22 03:05
共2个回答
热心网友 时间:2023-10-14 19:50
公式粘贴说明你的公式引用的参数位置发生变化,使用$符号定位就可以了,比如你的公式是=sum(c2:c5),如果要粘贴,请变成=sum($c$2:$c$5)就可以了热心网友 时间:2023-10-14 19:50
如果公式是=IF(ISNUMBER(FIND("鼠疫",L2)),"有",IF(ISNUMBER(FIND("霍乱",L2)),"有",IF(ISNUMBER(FIND("病毒性肝炎",L2)),"有",IF(ISNUMBER(FIND("乙肝",L2)),"有",IF(ISNUMBER(FIND("丙肝",L2)),"有",IF(ISNUMBER(FIND("丁肝",L2)),"有",IF(ISNUMBER(FIND("戊肝",L2)),"有",IF(ISNUMBER(FIND("脊灰",L2)),"有",IF(ISNUMBER(FIND("脊髓灰质炎",L2)),"有",IF(ISNUMBER(FIND("禽流感",L2)),"有",IF(ISNUMBER(FIND("麻疹",L2)),"有",IF(ISNUMBER(FIND("出血热",L2)),"有",IF(ISNUMBER(FIND("狂犬病",L2)),"有",IF(ISNUMBER(FIND("脑炎",L2)),"有",IF(ISNUMBER(FIND("登革热",L2)),"有",IF(ISNUMBER(FIND("炭疽",L2)),"有",IF(ISNUMBER(FIND("痢疾",L2)),"有",IF(ISNUMBER(FIND("菌痢",L2)),"有",IF(ISNUMBER(FIND("志贺氏菌",L2)),"有",IF(ISNUMBER(FIND("肺结核",L2)),"有",IF(ISNUMBER(FIND("涂阳",L2)),"有",IF(ISNUMBER(FIND("仅培养",L2)),"有",IF(ISNUMBER(FIND("菌阴",L2)),"有",IF(ISNUMBER(FIND("未痰检",L2)),"有",IF(ISNUMBER(FIND("伤寒",L2)),"有",IF(ISNUMBER(FIND("流脑",L2)),"有",IF(ISNUMBER(FIND("流行性脑脊髓炎",L2)),"有",IF(ISNUMBER(FIND("百日咳",L2)),"有",IF(ISNUMBER(FIND("白喉",L2)),"有",IF(ISNUMBER(FIND("新破",L2)),"有",IF(ISNUMBER(FIND("新生儿破伤风",L2)),"有",IF(ISNUMBER(FIND("猩红热",L2)),"有",IF(ISNUMBER(FIND("布鲁氏菌",L2)),"有",IF(ISNUMBER(FIND("布病",L2)),"有",IF(ISNUMBER(FIND("淋病",L2)),"有",IF(ISNUMBER(FIND("梅毒",L2)),"有",IF(ISNUMBER(FIND("钩体病",L2)),"有",IF(ISNUMBER(FIND("钩端螺旋体病",L2)),"有",IF(ISNUMBER(FIND("血吸虫病",L2)),"有",IF(ISNUMBER(FIND("疟疾",L2)),"有",IF(ISNUMBER(FIND("恶性疟",L2)),"有",IF(ISNUMBER(FIND("三日疟",L2)),"有",IF(ISNUMBER(FIND("卵型疟",L2)),"有",IF(ISNUMBER(FIND("流行*冒",L2)),"有",IF(ISNUMBER(FIND("流感",L2)),"有",IF(ISNUMBER(FIND("流腮",L2)),"有",IF(ISNUMBER(FIND("流行性腮腺炎",L2)),"有",IF(ISNUMBER(FIND("风疹",L2)),"有",IF(ISNUMBER(FIND("出血性结膜炎",L2)),"有",IF(ISNUMBER(FIND("麻风",L2)),"有",IF(ISNUMBER(FIND("黑热病",L2)),"有",IF(ISNUMBER(FIND("包虫",L2)),"有",IF(ISNUMBER(FIND("丝虫",L2)),"有",IF(ISNUMBER(FIND("手足口",L2)),"有",IF(ISNUMBER(FIND("感染性腹泻",L2)),"有",IF(ISNUMBER(FIND("轮状病毒",L2)),"有",IF(ISNUMBER(FIND("细菌性肠炎",L2)),"有",IF(ISNUMBER(FIND("病毒性肠炎",L2)),"有",IF(ISNUMBER(FIND("病毒性腹泻",L2))......