公式1:
IF(F4 = 62, if(K3 = 0, if(LEN(I4) = 0 && F4 = 62, 0, I4), K3), if(LEN(I4) = 0, "#$#", I4))
IF(F4 = 242,if(M3 = 0, if(LEN(I4) = 0 && F4 = 242, 0, I4), M3), if(LEN(I4) = 0, "#$#", I4))
直接说你的判断标准出来。。
if(f4=62,k3,if(f4=242,m3,if(f4<>62,l4,"")))
=Switch(F4,62,if(K3 = 0, if(LEN(I4) = 0 && F4 = 62, 0, I4), K3), if(LEN(I4) = 0, "#$#", I4),242,if(M3 = 0, if(LEN(I4) = 0 && F4 = 242, 0, I4), M3), if(LEN(I4) = 0, "#$#", I4))
用Switch直接可以,没必要一直嵌套IF语句
IF(F4=62,K3,(IF(F4=242,M3,L4)))