Hi
I need a bit of help with a nested IF AND formula. I can get nested IF's to work with no problem, however if I add and into the mix it seems to go awry. The data i have is as follows;
<tbody>
</tbody>
The equation is as follows;
IF(AND(A2>2190,B2="No","Yes",IF(AND(A2>1825,B2="Yes","Yes","No"))))
What I'm expecting is that row 1 and 2 would be 'Yes', rows 3 and 4 would be 'No', row 5 'Yes' and row 6 'No' - however I keep getting errors in the equation and can't seem to see where it's going wrong.
Thanks for any help.
Alex
I need a bit of help with a nested IF AND formula. I can get nested IF's to work with no problem, however if I add and into the mix it seems to go awry. The data i have is as follows;
A | B | |
1 | 2500 | Yes |
2 | 2500 | No |
3 | 1200 | Yes |
4 | 1200 | No |
5 | 1900 | Yes |
6 | 1900 | No |
<tbody>
</tbody>
The equation is as follows;
IF(AND(A2>2190,B2="No","Yes",IF(AND(A2>1825,B2="Yes","Yes","No"))))
What I'm expecting is that row 1 and 2 would be 'Yes', rows 3 and 4 would be 'No', row 5 'Yes' and row 6 'No' - however I keep getting errors in the equation and can't seem to see where it's going wrong.
Thanks for any help.
Alex