removing #DIV/0! & #VALUE!

[wberg82]

What do I need to do to this equation, so I don't get the #DIV/0! result?

=IF(E43<=(N43/2),((A25/(ROUNDDOWN((N43/E43),0)))*B43),A25*B43)

Same with #VALUE !

=IFERROR((D25/(ROUNDDOWN((O43/H43),0))),"")*B43

Thanks

 

[Phuoc]

=iferror(if(e43<=(n43/2),((a25/(rounddown((n43/e43),0)))*b43),a25*b43),"")

=iferror(d25/rounddown((o43/h43),0)*b43,"")

 

[Aladin Akyurek]

1.

=IF(E43<=(N43/2),IF(ISNUMBER(1/E43),((A25/(ROUNDDOWN((N43/E43),0)))*B43),"not available"),A25*B43)

2.

=IF(ISNUMBER(1/H43),(D25/(ROUNDDOWN(O43/H43,0)*B43,"")

Do these work for you?​

_{^{<strike>
</strike>}}​