excel表格中e2＝if(d2＝"","",d2/B2) F2＝if(C2＝"","",C2-E2＋F1)中当D2为空时f2则报

Question

excel表格中e2＝if(d2＝"","",d2/B2)
F2＝if(C2＝"","",C2-E2＋F1)中当D2为空时f2则报错，理想中的是D2为空E2则为0参与运算

Answer 1

将F2公式改为：
＝if(C2＝"","",C2-N(E2)＋F1)

Answer 2

=IF(C2="","",C2-N(E2)+F1)
=IF(C2="","",SUM(C2,F1)-SUM(E2))

Answer 3

F2＝if(C2＝"","",C2-E2＋F1)
修改为：
IFERROR(if(C2＝"","",C2-E2＋F1), "")

Answer 4

＝if(C2＝"","",C2-N(E2)＋F1)能解释下吗，后面两个我知道，就是不想用其它函数才问下这个技巧性问题