现EXCEL公式显示错误。请高手帮忙

Question

=if(b99="","",if(and(countif(h99:h96,">"&h95)>4)+and(min(h99:h855)>min(h99:75))),"@",""))不知道错哪里了。新手勿喷。谢谢！

Answer 1

参考：
=IF(B99="","",IF(AND(COUNTIF(H96:H99,">"&H95)>4)+AND(MIN(H99:H855)>MIN(H75:H99)),"@",""))
75前没有写H，括号不对

Answer 2

改为:
=if(b99="","",IF(AND(COUNTIF(H96:H99,">"&H95)>4,MIN(H99:H855)>MIN(H75:H99)),"@",""))

Answer 3

=IF(B99="","",IF(AND(COUNTIF(H96:H99,">"&H95)>4,MIN(H99:H855)>MIN(H75:H99)),"@",""))