Forum Discussion
James Love
Oct 27, 2018Copper Contributor
Formula error
Help needed. This formula =IF(U6="0","",SUM(F6+M6)/U6) is returning the #DIV/0! Error. Can anyone help me fix it, so it will return zero (0) or the cell remain blank. Thanks for your help.
1 Reply
- Detlef_LewinSilver Contributor
Hi
=IFERROR(SUM(F6,M6)/U6,0)