公式判断A1单元格等于04,值为100,A1单元格等于05,值为200
if(a1=="04","100",if(a1=="05","200","其他"))
-----------
可以改写为
SWITCH(A1,"04","100","05","200",A1,"其他")
if(a1='04',100,if(a1='05',200,""))