if函数:
if里面嵌套if:
=IF(A1>=10,"10+",IF(A1<=5,"5-","5-10"))
if里面嵌套and函数,表示必须同时满足and里面的所有条件才为真:
=IF(AND(I1<=5,I1>=1),"1-5","5+")
if里面嵌套or函数,表示只要满足or中的任一条件就为真:
if函数:
if里面嵌套if:
=IF(A1>=10,"10+",IF(A1<=5,"5-","5-10"))
if里面嵌套and函数,表示必须同时满足and里面的所有条件才为真:
=IF(AND(I1<=5,I1>=1),"1-5","5+")
if里面嵌套or函数,表示只要满足or中的任一条件就为真: