=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<78.2)),"粘土",IF(OR(AND(E7>42.3,E7<=48.9),AND(E7>50.9,E7<=64),AND(E7>69.9,E7<=73.5)),"粉質粘土",IF(AND(E7>64,E7<=66.8),"細砂夾粘土","")))))或=IF(E7<19,"淤泥",IF((E7>=19)*(E7<27)+(E7>=32.9)*(E7<35.9)+(E7>=40.4)*(E7<=42.3)+(E7>48.9)*(E7<=50.9)+(E7>66.8)*(E7<=69.9)+(E7>73.5)*(E7<=77.1),"卵石",IF((E7>=27)*(E7<32.9)+(E7>=35.9)*(E7<40.4)+(E7>77.1)*(E7<78.2),"粘土",IF((E7>42.3)*(E7<=48.9)+(E7>50.9)*(E7<=64)+(E7>69.9)*(E7<=73.5),"粉質粘土",IF((E7>64)*(E7<=66.8),"細砂夾粘土","")))))再簡化一下=IF(E7="","",LOOKUP(E7,{0,"淤泥";19,"卵石";27,"粘土";32.9,"卵石";35.9,"粘土";40.4,"卵石";42.301,"粉質粘土";48.901,"卵石";50.901,"粉質粘土";64.001,"細砂夾粘土";66.801,"卵石";69.901,"粉質粘土";73.501,"卵石";77.101,"粘土";78.2,""}))因為你原公式沒有說明E7=27時的情形,所以我讓全部公式E7>=27,E7<32.9時為"粘土"