OFFSET function and #DIV/0!

[moglione1]

I am trying to get rid of the #div/0! in my offset function. Is there a way anybody knows about. I am new to excel to am not very logic as yet.

the current code = =J7/(OFFSET(Production!L21,24*($D$4-1),0))*100

Regards

 

[Seti]

The simplest solution, although it adds overhead:

=IF(OFFSET(Production!L21,24*($D$4-1),0)=0,"whatever you want when you got div by 0",J7/(OFFSET(Production!L21,24*($D$4-1),0))*100)

 

[moglione1]

Thank you very much. That works perfectly