这个公式能不能简化?=IF(A1="H",H2*10,IF(A1="J",J2*10,IF(A1="K",K2*10,0

如何简化这个公式?=IF(A1="砖混",B1*10,IF(A1="砖草",B1*20,IF(A1="砖土",B1*30 公式=IF(A1 =IF(A1 英语翻译=IF($A1>10,IF(COLUMN(A1)=1,"大",""),IF(COLUMN(A1)=2,"小"," 在Excel中,如果已经知道A1=20,A2输入的公式为=IF(NOT(A1>50),IF(AND(A1>10,A1 F1=IF($A1="","",IF($A1-COLUMN(A1)+1=0,COLUMN()-6,"")) 右拉复制公式 A1 10-1 A2 A3=IF(A2="","TODAY()-A1+1",A2-A1),today()-A1+1怎么不 =IF(COUNTA($A1:$E1)>=COLUMN(A1),INDEX($A1:$E1,SMALL(IF($A1:$ excel 公式改写=CORREL(IF(1,OFFSET(A$1,0,ROW(A1)-1,10)),IF(1,OFFS =IF(SUM(A1:A5)>0,SUM(A1:A5) =IF(countif(a1:a100,">0")〈10,1.15*C7,0)为何为无效公式 EXCEL公式的意思=MID($A1,FIND("市",$A1)+1,IF(ISERROR(FIND("区",$A1))