IF statement work around.

[thecdnmole]

I have a formula that needs to have a few more "IF" statements, but I have maxed out the amount useable in Excel 2003. I read about splitting them into two cells, but that did not seem to work. Can someone here help? I will paste the current if statement and the variables that I need it to calculate. Thanks!


=IF(E4="active-air ESV",(F4+366),IF(E4="active-twin ESV",(F4+366),IF(E4="active-twin",(F4+366),IF(E4<>"active","",IF(ISBLANK(H4),"NEED DATE",IF(ISBLANK(F4),"Need DATE",IF(((F4)+(366*3))>=(H4+1735),"on hydro date",IF((I4)>=2009,(F4)+(365*3)+1,""))))))))


Active

Actve-air ESV

Active-air ISC

Active-twin

Active-twin ESV

Active-t/air ESV

Active-t/air ISC

Inactive

Out of Service

Sold

MIA

Junk/Scrap

For Sale

[Ace_XL]

Condensed...

=IF(OR(E4="active-air ESV",E4="active-twin ESV",E4="active-twin"),F4+366,IF(OR(ISBLANK(H4),ISBLANK(F4)),"NEED DATE",IF(F4+366*3>=H4+1735,"on hydro date",IF(I4>=2009,F4+365*3+1,""))))

[jeffreybrown]

You can start chipping away at the formula by combining the first part into...

=IF(OR(e4={"active-air ESV","active-twin ESV","active-twin"}),(F4+366)

[thecdnmole]

Thanks guys! With a bit of tweeking it works!!

[jeffreybrown]

Glad to hear you got it working and thanks for the feedback...