用*替换AND，并用+替换OR:

Replace AND with * and OR with +:

if(and(b2:b="Animal",OR(c2="small",c2="medium"))

成为:

if( (b2:b="Animal") * ((c2:c="small") + (c2:c="medium")) )

array-formula 必须一起工作.