| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Multiple if statements with multiple conditions
a b
1 TRUE 10 2 TRUE 8 3 2 4 4 5 TRUE 5 I'm trying to get an if function to work with multiple conditions. For example if(a1=true,a2=true,a5=true,sum(b3:b4), if (a1=true,a2=true,a5=false,sum(b3:b5), if a1=false,a2=false,a5=true,sum(b1:b4). First condition should =6, second=11, & third should be 24. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Autosum results of multiple if statements? | Excel Worksheet Functions | |||
| How do I return a value based on multiple possible conditions? | Excel Worksheet Functions | |||
| If Function with Multiple Conditions | Excel Discussion (Misc queries) | |||
| How do I sort data with multiple conditions? | Excel Worksheet Functions | |||
| Lookup with multiple conditions | Excel Discussion (Misc queries) | |||
Threaded Mode
