Trying to nest formulas/put them all in one cell but keep getting "too many arguments" error?

[Event2020]

Hi

I been working on this on and off for nearly 5 hours straight and when I look at the it everything just all blurs into a mess so I would be very grateful for a fresh perspective or pair of eyes.?

I am trying to combine the three formulas below in to one so that they are in the same Cell. Each formula performs a task depending on what is selected elsewhere in the worksheet and no matter what I do I keep getting the "too many arguments" error.

On their own each formula does exactly as I want.

I have tried the most obvious by nesting formula 2 inside formula 1's "value if false" area and then doing the same with formula 3 inside formula 2's "value if false" area but that did not work and I have tried different variations but everything I try throws a "too many arguments" error.

Here are the formulas in the order I would like them to run:
Formula 1.

=IF(AND(Add_CD_Information!B23=1,Add_CD_Information!B25=1),IF(Add_CD_Information!B48<>"",Add_CD_Information!B48,""),IF(AND(Add_CD_Information!B23={1},Add_CD_Information!B25={2}),CONCATENATE(Koolio_HTML!B158,Koolio_HTML!B159,Koolio_HTML!B160),""))

Formula 2.

=IF(Add_CD_Information!B23={3},Add_CD_Information!B48, "")

Formula 3

=IF(OR(Add_CD_Information!B23={2},Add_CD_Information!B23={4},Add_CD_Information!B23={5}),IF(Add_CD_Information!B48<>"",Add_CD_Information!B48,""),"")

I would be very grateful for any advice or help that you may be able to offer.

 

[Eric W]

There's a lot of redundancy in those formulas. Try this:

=IF(AND(Add_CD_Information!B23=1,Add_CD_Information!B25=2),Koolio_HTML!B158&Koolio_HTML!B159&Koolio_HTML!B160,IF(OR(Add_CD_Information!B23={1,2,3,4,5}),Add_CD_Information!B48,""))&""

It's not exactly the same, if B25=3 the formulas will diverge, but if that's an issue let me know.

 

[Event2020]

There's a lot of redundancy in those formulas. Try this:

=IF(AND(Add_CD_Information!B23=1,Add_CD_Information!B25=2),Koolio_HTML!B158&Koolio_HTML!B159&Koolio_HTML!B160,IF(OR(Add_CD_Information!B23={1,2,3,4,5}),Add_CD_Information!B48,""))&""

It's not exactly the same, if B25=3 the formulas will diverge, but if that's an issue let me know.

Hi Eric

How on earth did you manage to condense my original formulas down into a single short one, I am in awe?

I have done a very quick test and it seems to work perfectly but I will test it more thoroughly tomorrow.

Just from looking at your formula I honestly can not see how you did it.

Thank you so much, I really appreciate your help.

Kind regards

Kenneth

 

[Eric W]

Well, it took a few passes. That was about the third iteration. I found one thing to combine, and looked at the result and found something else to change. The &"" on the end was key to removing a lot of If xx="","" sections. I hope at least you can figure out how it works now though!

Glad I could help!