（在线等）很简单的excel问题，求计算公式

来源：百度知道编辑：UC知道时间：2024/06/10 06:15:08

如果a>b或者a>c,则ok，否则bad；

还有一个：如果a大于b小于c，则OK，否则bad

=if(or(a>b,a>c),"ok","bad")
=if(and(a>b,a<c),"ok","bad")

公式中的a,b,c可以是具体数值，也可以是单元格坐标

=IF(OR(A1>B1,A1>C1),"OK","BAD")
=IF(AND(A1>B1,A1<C1),"OK","BAD")

if(or(a>b,a>c),"OK","bad")
if(and(a>b,b<c),"OK","bad")

=IF(OR(A>B,A>C),"OK","bad")
=IF(AND(A>B,A<C),"OK","bad")

1、=IF((A1>B1)+(A1>C1),"ok","bad")
或者
=IF(OR(A1>B1,A1>C1),"ok","bad")

2、=IF((A1>B1)*(A1<C1),"ok","bad")
或者
=IF(AND(A1>B1,A1<C1),"ok","bad")