I am trying to use an IIF formula to avoid dividing by zero that causes an #Error but can not seem to get it right.
Essentially what i need is to divide
sum of bill and non bill hours by sum of std and leave hours.
Problem is when Std and Leave hours are the same value, the result is Zero hence when dividing by zero causes an error.
Any help would be appreciated, and thanks in anticipation.