if函数怎么表达a>1,且4<b<5
发布网友
发布时间:2022-04-28 20:06
我来回答
共1个回答
热心网友
时间:2022-06-23 01:02
=IF(AND(A1>1,B1>4,B1<5),"正确","错误")
或=IF((A1>1)*(B1>4)*(B1<5),"正确","错误")
详细请参考
http://ke.baidu.com/link?url=73zOWCatQgfluCSPzf09UYzujoNj59pxkZQMZLOgEiEaXWl6wHEHWLVpBs1ICzJXUD-UageZ3CIYWuHjXv9fEw3b0QthmMiLoOdZ8Kw5MiG