Hi All,
Currently i have an issue where i want to have 15 if(and functions that have 4 conditions in each but it says im not allowed have that many in a nested if statement.
An example of the current formula i am using is:
=IF(AND(H2="Y",I2="Y",J2="Y",K2="Y"),"All are available",IF(AND(H2="Y",I2="Y",J2="Y",K2="N"),"Jess",IF(AND(H2="Y",I2="Y",J2="N",K2="Y"),"Dave",IF(AND(H2="N",I2="Y",J2="Y",K2="N"),"Derek",IF(AND(H2="Y",I2="Y",J2="Y",K2="N"),"Paul",IF(AND(H2="Y",I2="Y",J2="Y",K2="N"),"Dave and jess",IF(AND(H2="Y",I2="Y",J2="Y",K2="N"),"Dave jess and Paul","No one available")))))))
This is the table i am working from. So basically just needs to let me know who is not free for the party?
<tbody>
</tbody><colgroup><col span="4"><col><col></colgroup>
Currently i have an issue where i want to have 15 if(and functions that have 4 conditions in each but it says im not allowed have that many in a nested if statement.
An example of the current formula i am using is:
=IF(AND(H2="Y",I2="Y",J2="Y",K2="Y"),"All are available",IF(AND(H2="Y",I2="Y",J2="Y",K2="N"),"Jess",IF(AND(H2="Y",I2="Y",J2="N",K2="Y"),"Dave",IF(AND(H2="N",I2="Y",J2="Y",K2="N"),"Derek",IF(AND(H2="Y",I2="Y",J2="Y",K2="N"),"Paul",IF(AND(H2="Y",I2="Y",J2="Y",K2="N"),"Dave and jess",IF(AND(H2="Y",I2="Y",J2="Y",K2="N"),"Dave jess and Paul","No one available")))))))
This is the table i am working from. So basically just needs to let me know who is not free for the party?
Paul | Derek | Dave | jess | Option | Not available |
Y | Y | Y | Y | 15 | All Are availble |
Y | Y | Y | N | 14 | Jess |
Y | Y | N | Y | 13 | Dave |
Y | N | Y | Y | 12 | Derek |
N | Y | Y | Y | 11 | Paul |
Y | Y | N | N | 10 | Dave and Jess All help greatly appreciated, thanks |
<tbody>
</tbody><colgroup><col span="4"><col><col></colgroup>