If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
IF AND help!
What's the formula for: If A1=2 or A11 then B1 If A2 then C1 If A=1 then 0 I assume it'll be an extensions of this formula which is missing the A12 part: IF(AND(A1=2,A11),B1,0) Thanks a million! -- acebrown ------------------------------------------------------------------------ acebrown's Profile: http://www.excelforum.com/member.php...o&userid=36640 View this thread: http://www.excelforum.com/showthread...hreadid=568107 |
#2
|
|||
|
|||
IF AND help!
"acebrown" wrote in
message ... What's the formula for: If A1=2 or A11 then B1 If A2 then C1 If A=1 then 0 I assume it'll be an extensions of this formula which is missing the A12 part: IF(AND(A1=2,A11),B1,0) =IF(A12,C1,IF(A11,B1,0)) assuming that your first condition was intended to be "and", not "or", and that where you said A in your 2nd & 3rd conditions you intended A1. -- David Biddulph |
Thread Tools | |
Display Modes | |
|
|