IF to evaluate errors also

hsandeep

Well-known Member
Joined
Dec 6, 2008
Messages
950
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

Well-known Member
Joined
Dec 3, 2018
Messages
8,974
Office Version
2007
Platform
Windows
Try this

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

DanteAmor

Well-known Member
Joined
Dec 3, 2018
Messages
8,974
Office Version
2007
Platform
Windows
I'm glad to help you. Thanks for the feedback.
 

Forum statistics

Threads
1,082,601
Messages
5,366,571
Members
400,902
Latest member
fathima

Some videos you may like

This Week's Hot Topics

Top