Home » Forums » Open Source Learning Center » Question and Answer

help with iferrror function

Submitted by tonyp1969 on 28 August, 2013 - 10:55

Hi could anyone help with this, I am trying to get a display of NA instead of #div0! but cannot get the formula correct.

formula =C3/(24*B3)(if c3 and b3 contain no data then get the result of #div0!)
I have tried =C3/(24*B3)iferror(c3/(24*b3)),"na" but it returns an error.

Any help much appreciated.

‹ Insert cut row in protected range of rows Creating an XML from Excel ›
»

Hi

Submitted by Jon on 28 August, 2013 - 15:04.

This formula prevents returning zero or returning error when there is a zero values in B3 or C3

=IF(C3*B3=0,"",C3/(24*B3))

Hope this helps

»

Yes thank you that does

Submitted by tonyp1969 on 28 August, 2013 - 17:26.

Yes thank you that does remove the error but I would like it to display something like NA. Is that possible.

»

Here you go

Submitted by Jon on 28 August, 2013 - 18:03.

=IF(C3*B3=0,"NA",C3/(24*B3))

:)

»

Thank you so much for your

Submitted by tonyp1969 on 28 August, 2013 - 19:14.

Thank you so much for your help.

»

Use of Iferror

Submitted by Tanujkumar88 on 12 September, 2013 - 13:20.

Dear,

Your function is almost correct just you have to remove one bracket.

Correct Function

=Iferror(C3/(24*B3),"NA")

Thanks
Tanuj

»