Embedded If Statements

[keridvp1]

I have the following formula that works:

=IFERROR(IF(AND(D5="Y",E5="Y"),C5*$G$2,0),"")

I need to add an additional piece that says to look at a cell in B5 and if it says INACTIVE then multiple C5 with G1, otherwise I want it to do the original formula posted above.

I have not successfully been able to add this piece without an error.

 

[Joe4]

Add one more level of IF, i.e.

=IFERROR(IF(AND(D5="Y",E5="Y"),IF(B5="Inactive",C5*$G$1,C5*$G$2),0),"")

 

[DanteAmor]

A couple of ideas.

Try:

=IFERROR(IF(AND(D5="Y",E5="Y"),C5*IF(B5="Inactive",$G$1,$G$2),0),"")

Or:

=IFERROR(IF(D5&E5="YY",C5*IF(B5="Inactive",$G$1,$G$2),0),"")

 

[salim hasan]

try this formula
=CHOOSE(AND(UPPER(D5)="Y",UPPER(E5)="Y",UPPER(B5)="INACTIVE")+1,"",C5*$G$2)

 

[keridvp1]

add one more level of if, i.e.

=iferror(if(and(d5="y",e5="y"),if(b5="inactive",c5*$g$1,c5*$g$2),0),"")

thank you!!! This worked!!!

 

[Joe4]

You are welcome.