=if(and(A1="",A2=""),0,10) 两个都为空者返回0,否则返回10
=if(or(A1="",A2=""),0,10) 其中一个为空者返回0,否则返回10
=if(A1="",0,if(A2="",1,2)) A1一个为空者返回0,否则判断A2,A2为空则返回1,否则返回2
=if(and(A1="",A2=""),0,10) 两个都为空者返回0,否则返回10
=if(or(A1="",A2=""),0,10) 其中一个为空者返回0,否则返回10
=if(A1="",0,if(A2="",1,2)) A1一个为空者返回0,否则判断A2,A2为空则返回1,否则返回2
转载于:https://my.oschina.net/u/3471785/blog/3098616