View Single Post
  #1   Report Post  
JB
 
Posts: n/a
Default IF Worksheet Function

I've created the following formula,
=IF(AND(D3="Back Up",E3="ABCD04C00",F3<=6),"10.10.1.0 /22","0"),
IF(AND(D3="Back Up",E3="ABCD04C01",F3<=6),"10.10.2.0 /22","0"),
IF(AND(D3="Back Up",E3="ABCD04C02",F3<=6),"10.10.3.0 /22","0"),
IF(AND(D3="Back Up",E3="ABCD04C03",F3<=6),"10.10.4.0 /22","0"),
IF(AND(D3="Back Up",E3="ABCD04C04",F3<=6),"10.10.5.0 /22","0"),
IF(AND(D3="Back Up",E3="ABCD04C05",F3<=6),"10.10.6.0 /22","0")

The first expression from =sign to )parenthesis, works well, however, when I
add the additional expressions, I get the following result #VALUE!. I need to
know how to make this work to allow me to obtain a variety of TRUE results. I
will need to add approximately 100 expressions. If these is a more efficient
way to accomplish this, I'm all ears. All suggestions are welcome.