excel A3=B3+C3=D3+E3+F3+G3=H3+I3+J3+K3 否则“错误”怎么编?

2025-04-14 12:50:30
推荐回答(2个)
回答1:

=IF(AND(A3=(B3+C3),A3=(D3+E3+F3+G3),A3=(H3+I3+J3+K3)),"正确","错误")

回答2:

请用公式:
=IF(AND(A3=B3+C3,A3=D3+E3+F3+G3,A3=H3+I3+J3+K3),"正确","错误")