| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Automatically up date time in a cell | Excel Discussion (Misc queries) | |||
| SUMIF function referring to values on different Worksheet | Excel Worksheet Functions | |||
| Hyperlinks using R[1]C[1] and offset function in its cell referenc | Excel Worksheet Functions | |||
| The Help on the Excel Edate worksheet function contains an error:. | Excel Worksheet Functions | |||
| HOW CAN I GET OFFICE 2003 EXCEL BASIC TO NEST FUNCTIONS LIKE EXCE. | Excel Worksheet Functions | |||
Threaded Mode
