麻烦再写一个excel函数谢谢 数A1 函数写在B1 如果A1小于等于-10且大于等于-

Question

麻烦再写一个excel函数谢谢
数A1 函数写在B1
如果A1小于等于-10且大于等于-20 返回值0.8

Answer 1

楼上正解,,,不过再给你补充个公式吧
=AND(A1<=-10.A1>=-20)*0.8

Answer 2

=IF(AND(A1<=-10.A1>=-20),0.8,"")

Answer 3

=IF(AND(A1>=-20,A1<=-10),0.8,"")