Excel 2007 : Avoid the #div/0 error

[berk21]

can a cell not show this if a 0 is in a cell being calulated?

example cells P23 L23

[VBA Noob]

Try

=IFERROR(O10/L10,0)

to work with other versions of excel try

=IF(ISERROR(O10/L10),0,O10/L10)

VBA Noob

[berk21]

Thank you.
If I have another question not referring to the #DIV/0, do I create another thread with this one resolved?

[VBA Noob]

Yes please

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save