#Div/0! issue

[brazill23]

HI All,

I have slightly long formula but i have some issues with #Div/0! fault in some of the returns. Do you know how I can adjust formula to return 0 in case of issue ?

=IF(Q8>Q9,Q9/Q8,IF(Q8+R8>Q9,1+(Q9-Q8)/R8,IF(Q8+R8+S8>Q9,2+(Q9-Q8-R8)/S8,IF(Q8+R8+S8+T8>Q9,3+(Q9-Q8-R8-S8)/T8,IF(Q8+R8+S8+T8+U8>Q9,4+(Q9-Q8-R8-S8-T8)/U8,IF(Q8+R8+S8+T8+U8+V8>Q9,5+(Q9-Q8-R8-S8-T8-U8)/V8,IF(Q8+R8+S8+T8+U8+V8+W8>Q9,6+(Q9-Q8-R8-S8-T8-U8-V8)/W8,IF(Q8+R8+S8+T8+U8+V8+W8+X8>Q9,7+(Q9-Q8-R8-S8-T8-U8-V8-W8)/X8,"8+"))))))))

any ideas ?

Thank You all

 

[Joe4]

You could just wrap the whole formula in an IFERROR formula:

[COLOR=#ff0000]=IFERROR([/COLOR][COLOR=#333333]IF(Q8>Q9,Q9/Q8,IF(Q8+R8>Q9,1+(Q9-Q8)/R8,IF(Q8+R8+S8>Q9,2+(Q9-Q8-R8)/S8,IF(Q8+R8+S8+T8>Q9,3+(Q9-Q8-R8-S8)/T8,IF(Q8+R8+S8+T8+U8>Q9,4+(Q9-Q8-R8-S8-T8)/U8,IF(Q8+R8+S8+T8+U8+V8>Q9,5+(Q9-Q8-R8-S8-T8-U8)/V8,IF(Q8+R8+S8+T8+U8+V8+W8>Q9,6+(Q9-Q8-R8-S8-T8-U8-V8)/W8,IF(Q8+R8+S8+T8+U8+V8+W8+X8>Q9,7+(Q9-Q8-R8-S8-T8-U8-V8-W8)/X8,"8+"))))))))[/COLOR][COLOR=#ff0000],0)[/COLOR][COLOR=#333333][/COLOR]