how to get formula to work that shows a - when the answer should be 0
Hi trying to get a formula to work in E3, E4, E5, E6,E7 & so on
the formula is I think correct for E3, E5, E7
=IF($A3="","",IF(D3=0,B3-C3,IF(D3>=0,B3+D3-C3)))
the problem I'm having is that E4, E6 show a - when the answer should be 0
I'm new to excel and don't know how I can over come this issue
If anyone can help I'd be grateful
|