Hey can some one please help me....
I am not to sure why this code is not working....
=IF(AND((D17=6),((YEAR(NOW())-YEAR(K5))<25),(N13>=3),(F11+H11+J11+L11+N11)=0),5,IF(AND((D17=6),((YEAR(NOW())-YEAR(K5))<25),(N13>=5),(F11+H11+J11+L11+N11)=0),3,D17))
All i want this to do is.... either put a 5 or a 3 and if not just put whatever is in D17, but it wont work...
Thanks heaps in advance!
I am not to sure why this code is not working....
=IF(AND((D17=6),((YEAR(NOW())-YEAR(K5))<25),(N13>=3),(F11+H11+J11+L11+N11)=0),5,IF(AND((D17=6),((YEAR(NOW())-YEAR(K5))<25),(N13>=5),(F11+H11+J11+L11+N11)=0),3,D17))
All i want this to do is.... either put a 5 or a 3 and if not just put whatever is in D17, but it wont work...
Thanks heaps in advance!