在EXCEL中怎样用函数计算复杂的运算

1个回答

=IF(V4=0,IF(T4=0,U4,IF(U4=0,T4,IF(AND(T40,U40),T4+U4))),IF(V40,IF(T4=0,U4-V4,IF(U4=0,T4-U4,IF(AND(T40,U40),T4+U4-V4)))))