excel公式,在wps里面用的好好的,今天自动升级了,公式就不能用了,说输 ...答:新版本的WPS表格可以新建.xlsx格式文档。你也可以用下面的公式:=IFERROR(LOOKUP(1,0/FIND({"sogou","xiongbu","shoushen","yanmeibu","bibu","xiaba","tuomao","chuzhou","bahen","jiguang","weizhengxing","zhengxing","hongxuesi","quban","taiji","quchu","simi","miankuo","kou...
急急急,WPS【你输入的公式存在错误,如果你输入的内容不是公式】,请在...答:=IF(E7<19,"淤泥",IF(OR(AND(E7>=19,E7<27),AND(E7>=32.9,E7<35.9),AND(E7>=40.4,E7<=42.3),AND(E7>48.9,E7<=50.9),AND(E7>66.8,E7<=69.9),AND(E7>73.5,E7<=77.1)),"卵石",IF(OR(AND(E7>=27,E7<32.9),AND(E7>=35.9,E7<40.4),AND(E7>77.1,E7<...