怎样用Excel if函数编写

Question

怎样用Excel if函数编写 1.如果M5=0,则N5=0;M5≠0时,N5=L5/M5 2.如果H5=0,J5≠0，则K5＝I5/J5;如果J5=0,H5≠0，则k5=G5/H5;如果H5≠0,J5≠0,则K5=(I5/J5+G5/H5).谢了！

Answer 1

Excel表格IF函数怎么用？这个视频告诉你！

Answer 2

N5 = If(M5=0,0,L5/M5)
K5 = If(And(H5=0,J5<>0),I5/J5,If(And(J5=0,H5<>0),G5/H5,I5/J5+G5/H5)本回答被网友采纳

Answer 3