| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| change "true" and "false" to "availble" and "out of stock" | Excel Worksheet Functions | |||
| Combining formulas, "and" & "or" to verify content of multiple cel | Excel Discussion (Misc queries) | |||
| "Control" plus "click" doesn't allow me to select multiple cells | New Users to Excel | |||
| Count occurences of "1"/"0" (or"TRUE"/"FALSE") in a row w. conditions in the next | New Users to Excel | |||
| freeze window creates multiple "views" suffixed with ":n" | Excel Discussion (Misc queries) | |||
Linear Mode
