Issue with IF statement

**DennyMathews** · 10-09-2012, 05:27 AM

Hi,

I need help with the below nested IF statement -

=IF(OR(OR(YEAR(F5)=2012,YEAR(F5)=2013),YEAR(F5)=2013),IF(OR(15<Z5,AA5<1),0,(N5*IF(AND(Z5<1, AA5>15),15,IF(Z5>=1,15-Z5+1,AA5-1+1)))/(T5)), IF(OR(15<AB5,AC5<1),0,(O5*IF(AND(AB5<1, AC5>15),15,IF(AB5>=1,15-AB5+1,AC5-1+1)))/(U5)), IF(OR(15<AD5,AE5<1),0,(P5*IF(AND(AD5<1, AE5>15),15,IF(AD5>=1,15-AD5+1,AE5-1+1)))/(V5)), IF(OR(15<AF5,AG5<1),0,(Q5*IF(AND(AF5<1, AG5>15),15,IF(AF5>=1,15-AF5+1,AG5-1+1)))/(W5)), IF(OR(15<AH5,AI5<1),0,(R5*IF(AND(AH5<1, AI5>15),15,IF(AH5>=1,15-AH5+1,AI5-1+1)))/(X5)), IF(OR(15<AJ5,AK5<1),0,(S5*IF(AND(AJ5<1, AK5>15),15,IF(AJ5>=1,15-AJ5+1,AK5-1+1)))/(Y5)),0)))))

I get an error 'too many arguments'

I tried combining six different IF statements. Can you please help?

Regards,
D

**dilipandey** · 10-09-2012, 06:07 AM

Hi Denny,

Welcome to the forum.

Please share the logic which you wanted to apply here... also if possible, upload a sample workbook. Thanks.

Regards,
DILIPandey

<click on below 'star' if this helps>

**Jacc** · 10-09-2012, 06:41 AM

I can help with putting in some spaces and linebreaks.

Formula:

Please Login or Register  to view this content.

I have no idea of what's wrong but this looks way too much to be in one cell if you ask me. I would split it up to 7 columns or so. There is most likely a smarter way to do, let's hope that a forum member that is more formula oriented than me picks this up.

**DennyMathews** · 10-09-2012, 09:48 AM

Originally Posted by dilipandey

Hi Denny,

Welcome to the forum.

Please share the logic which you wanted to apply here... also if possible, upload a sample workbook. Thanks.

Regards,
DILIPandey

<click on below 'star' if this helps>

Hi Dilip,

Thank you.

I am working on a capacity model and the logic is % involvement for each of the phases.
This is what I was trying to combine -

Requirement Phase Formula - This req phase formula is for 1st half of Jan'12.

=IF(OR(OR(YEAR(F5)=2012,YEAR(F5)=2013),YEAR(F5)=2013),IF(OR(15<Z5,AA5<1),0,(N5*IF(AND(Z5<1, AA5>15),15,IF(Z5>=1,15-Z5+1,AA5-1+1)))/(T5)),0)

Formuals for other phases are also ready.

Design Phase - (IF(OR(15<AB5,AC5<1),0,(O5*IF(AND(AB5<1, AC5>15),15,IF(AB5>=1,15-AB5+1,AC5-1+1)))/(U5)),0))

Construction Phase - IF(OR(15<AD5,AE5<1),0,(P5*IF(AND(AD5<1, AE5>15),15,IF(AD5>=1,15-AD5+1,AE5-1+1)))/(V5)),0)

Test Phase - IF(OR(15<AF5,AG5<1),0,(Q5*IF(AND(AF5<1, AG5>15),15,IF(AF5>=1,15-AF5+1,AG5-1+1)))/(W5)),0)

Implementation Phase - IF(OR(15<AH5,AI5<1),0,(R5*IF(AND(AH5<1, AI5>15),15,IF(AH5>=1,15-AH5+1,AI5-1+1)))/(X5)),0)

Post Implementation Phase - IF(OR(15<AJ5,AK5<1),0,(S5*IF(AND(AJ5<1, AK5>15),15,IF(AJ5>=1,15-AJ5+1,AK5-1+1)))/(Y5)),0)

I tried to combine it as one formula.

Regards,
Denny