Multiple "IFAND"
 

try:

=IF(AND(J4=high_cost_limit,E4=0,G4=0),"High",IF(A ND(J4=high_cost_limit,OR(E4<0,G4<0)),"High_Unfi nished","Low"))

"pjk@boro" wrote:

I have 5 columns (D,E,F,G,J). D+E=F. F+G=J. I also have a cell named "HCL".
If J is GE "HCL" & both E & G = zero, then formula should return "High".
If J is GE "HCL" but either E or G is not equal to zero, then formula should
return "High_Unfinished".
Otherwise it should return "Low". My formula is;
"IF(AND(J4=high_cost_limit,E4=0,G4=0),"High",IF(A ND(J4=high_cost_limit,E4<0,),"High_Unfinished",I F(AND(J4=high_cost_limit,G4<0,),"High_Unfinished ","Low")))".
It is only retuning "High" or "Low" but not "High_Unfinished".
any ideas where I'm going wrong?

Multiple "IFAND"
 

a further simplification if E4 and G4 will not have different signs
=IF(J4=high_cost_limit.if(E4+G4=0,"High","High_Un finished"),"Low"))


"pjk@boro" wrote:

Thanks very much Toppers. That's what I get for trying to be too complicated.

"Toppers" wrote:

try:

=IF(AND(J4=high_cost_limit,E4=0,G4=0),"High",IF(A ND(J4=high_cost_limit,OR(E4<0,G4<0)),"High_Unfi nished","Low"))

"pjk@boro" wrote:

I have 5 columns (D,E,F,G,J). D+E=F. F+G=J. I also have a cell named "HCL".
If J is GE "HCL" & both E & G = zero, then formula should return "High".
If J is GE "HCL" but either E or G is not equal to zero, then formula should
return "High_Unfinished".
Otherwise it should return "Low". My formula is;
"IF(AND(J4=high_cost_limit,E4=0,G4=0),"High",IF(A ND(J4=high_cost_limit,E4<0,),"High_Unfinished",I F(AND(J4=high_cost_limit,G4<0,),"High_Unfinished ","Low")))".
It is only retuning "High" or "Low" but not "High_Unfinished".
any ideas where I'm going wrong?

Multiple "IFAND"
 

Thanks very much Toppers. That's what I get for trying to be too complicated.

"Toppers" wrote:

try:

=IF(AND(J4=high_cost_limit,E4=0,G4=0),"High",IF(A ND(J4=high_cost_limit,OR(E4<0,G4<0)),"High_Unfi nished","Low"))

"pjk@boro" wrote:

I have 5 columns (D,E,F,G,J). D+E=F. F+G=J. I also have a cell named "HCL".
If J is GE "HCL" & both E & G = zero, then formula should return "High".
If J is GE "HCL" but either E or G is not equal to zero, then formula should
return "High_Unfinished".
Otherwise it should return "Low". My formula is;
"IF(AND(J4=high_cost_limit,E4=0,G4=0),"High",IF(A ND(J4=high_cost_limit,E4<0,),"High_Unfinished",I F(AND(J4=high_cost_limit,G4<0,),"High_Unfinished ","Low")))".
It is only retuning "High" or "Low" but not "High_Unfinished".
any ideas where I'm going wrong?