Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Nesting IF statements
I have a series of numbers representing sixteen bit binary:
0010110110001001 0011111110001001 0100000100010001 0100010011010000 In the next column I have a formula: =IF(BIN2DEC(MID(A1,2,1))=1, "NET", "OpID") The contents of the third column would depend on the result of this formula such that if the second contains "OpID" this one will contain "Private". However, if the second column value is "NET" then I need to look at BIN2DEC(MID(A1,3,2))) and make the third column value "National" if this evaluates to 1 or 2 but "Private" if any other value is returned. Is it possible to nest If statements to do this or would I have to evaluate it in separate steps? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Nesting IF statements
=IF(B1="NET",IF(OR(BIN2DEC(MID(A1,3,2))=1,BIN2DEC( MID(A1,3,2))=2),"National"
,"Private"),"Private") -- HTH Bob Phillips (remove nothere from the email address if mailing direct) wrote in message ... I have a series of numbers representing sixteen bit binary: 0010110110001001 0011111110001001 0100000100010001 0100010011010000 In the next column I have a formula: =IF(BIN2DEC(MID(A1,2,1))=1, "NET", "OpID") The contents of the third column would depend on the result of this formula such that if the second contains "OpID" this one will contain "Private". However, if the second column value is "NET" then I need to look at BIN2DEC(MID(A1,3,2))) and make the third column value "National" if this evaluates to 1 or 2 but "Private" if any other value is returned. Is it possible to nest If statements to do this or would I have to evaluate it in separate steps? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Nesting IF statements
On 6-Mar-2006, "Bob Phillips" wrote: " ,"Private"),"Private") Many thanks Bob. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
UDFunctions and nested If-the-else statements | Excel Worksheet Functions | |||
Nesting IF statements, Conditional Formatting | Excel Discussion (Misc queries) | |||
nesting if statements | Excel Worksheet Functions | |||
Nesting more than nine IF statements in Excel | Excel Worksheet Functions | |||
Nesting IF Statements Based on Same Cell Value | Excel Worksheet Functions |