I need help with a #DIVIDE BY ZERO issue
I have a formula where 4 columns figures are weighted in a 20/80 split:
=((([Energy & GHG assessment Completed in cycle]81 / [Energy & GHG assessment Expected in cycle]81) * 0,2)) + ((([E&GHG Completed Tasks (end reporting period)]81 / [E&GHG Expected tasks (end reporting period)]81) * 0,8))
If one of the scores results in 0 then the entire outcome results in an error message: #DIVIDE BY ZERO
I would like it to know that if the outcome is 0 that it should then accordingly allocate that towards the weighting. IE: if the 80% portion resultsin 0 then the answer should be 20% and vice versa. OR if both as 0 then it should result in 0% (not an error message).
I am not savvy enough to know how to do this though - Please help!
Help Article Resources
Check out the Formula Handbook template!