#DIV/0! error in excel

[Pinaceous]

Hi All,

I'm working with sheet formulas where I'm getting a #DIV/0! error in excel with sheet formula

=L136/L236

.

I realize that the cell may have a zero value in it, which is causing the error and would like it to produce a zero then with

=IFERROR(L136/L236),0)

but now it is telling me that I'm entering in to few arguments.

Can someone please help?

Thanks!
pinaceous

 

[DanteAmor]

Try, You must remove a parenthesis:

=IFERROR(L136/L236,0)

 

[Pinaceous]

Thanks DanteAmor!

Good to hear from you!
pinaceous