Help combining IF statements

[Excel-erate2004]

I have 2 If statements (excel formula's) from an older project that I need to combine, if this was in VBA I could easily write a classic IF ELSE statement. However, I'm having a bit of trouble combining them as a excel formula.

Any ideas on how to combine these?

Heres my pseudo code:

Please Login or Register  to view this content.

Thanks for any help I can get!

Cheers!

[daddylonglegs]

I'd still look at shortening the longer formula as per your other thread but, irrespective, the IF worksheet syntax is fairly straightforward

=IF('Step1'!IQ10=TRUE,short formula,long formula)

[Excel-erate2004]

Cool, I'll give it a try, shouldnt be too bad, I just have problems with brackets sometimes.

I'll post my solution once I get it.

Thanks!

[Excel-erate2004]

Heres the solution:

Please Login or Register  to view this content.