Hi People,
I posted this yesterday and still can not get the code to work.
Basically what I need I think is quiet simple. I think!
I need excel to look if one of the two statement are true and if there not then it will equal what ever is in cell D17. The statements however will never be true together it can only be one or the other.
Here is the code I am using. The code only works if I remove the second statement.
1st Statement,
=IF(AND((D17=6),((YEAR(NOW())-YEAR(K5))<25),(N13>=3),(F11+H11+J11+L11+N11)=0),5,
2nd Statement,
IF(AND((D17=6),((YEAR(NOW())-YEAR(K5))<25),(N13>=5),(F11+H11+J11+L11+N11)=0),3,
and if not,
D17))
Thanks Heaps in ADVANCE.
I posted this yesterday and still can not get the code to work.
Basically what I need I think is quiet simple. I think!
I need excel to look if one of the two statement are true and if there not then it will equal what ever is in cell D17. The statements however will never be true together it can only be one or the other.
Here is the code I am using. The code only works if I remove the second statement.
1st Statement,
=IF(AND((D17=6),((YEAR(NOW())-YEAR(K5))<25),(N13>=3),(F11+H11+J11+L11+N11)=0),5,
2nd Statement,
IF(AND((D17=6),((YEAR(NOW())-YEAR(K5))<25),(N13>=5),(F11+H11+J11+L11+N11)=0),3,
and if not,
D17))
Thanks Heaps in ADVANCE.