IF to evaluate errors also

[hsandeep]

I want to fill D2 as per below criteria’s

D2=E2 if B2>0
D2=F2 if B2<0
D2=0 if B2=zero 0 or B2’s formula evaluates to an error. The following error types are evaluated: #N/A, #VALUE!, #REF!, #DIV/0!, #NUM!, #NAME?, or #NULL!.

How to accomplish please?

 

[DanteAmor]

Try this

=IFERROR(IF(B2=0,0,IF(B2>0,E2,F2)),0)

 

[hsandeep]

Try this

=IFERROR(IF(B2=0,0,IF(B2>0,E2,F2)),0)

It works. Thanks

 

[DanteAmor]

I'm glad to help you. Thanks for the feedback.