Good morning everyone.
I've entered the following formula =IF(V5<4,"0",SUM(L5)/K5). Where K5 sometimes = zero the result is obviously a #DIV/0! error.
I think that the solution could be found by embedding "=IF(K5=0,"", (L5)/K5)" into the formula but I'm not sure how. Can anybody help me on this please, or suggest a simpler/more efficient solution. By the way, I've had to use the "sum(L5)/K5" in order to resolve an earlier error report.
Thanks
Bookmarks