Need help with code!

[walky82]

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!

 

[northwolves]

Try:
=(D17=6)*(YEAR(NOW()-YEAR(K5))<25)*(F11+H11+J11+L11+N11=0)*IF(N13>=5,3,IF(N13>=3,5,D17))

Regards
Northwolves

 

[walky82]

Thanks for your help but that didn't work.

Not to sure why not... Thanks anyways

 

[northwolves]

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...
-------------------
A bit Ambiguous ,maybe an example can help you to Explanate it.

Regards
Northwolves

 

[walky82]

Sorry mate about the ambiguity.. This a two scenarios that can be either true or false...<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
<o></o>
=IF(AND((D17=6),((YEAR(NOW())-YEAR(K5))<25),(N13>=3),(F11+H11+J11+L11+N11)=0),5, - If this statement is true a 5 will be entered into that cell. <o></o>
<o></o>
<o></o>
IF(AND((D17=6),((YEAR(NOW())-YEAR(K5))<25),(N13>=5),(F11+H11+J11+L11+N11)=0),3, - If this statement in true it will put a 3 in the cell<o></o>
<o></o>
<o></o>
D17)) - If not whatever is in cell d17 will appear in the cell<o></o>