| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Hybrid Mode
