Don't show a formula if cell is empty

[Edwin_SVRZ]

I have the following formula: (the formula is in Dutch)

=ALS(D2="";"('"&A2&"', '"&TEKST(C2;"jjjj-mm-dd")&"', '"&E2&"'),";"('"&A2&"', '"&TEKST(C2;"jjjj-mm-dd")&"', '"&D2&"'),")

What this does it it checks if cell D2 is empty. If so it uses the value of cell E2 and if it's not empty it uses the value of cell D2 in the formula.
This works, but if I copy the formula to +500 rows and I only have 400 rows, it shows a part of the formula, since there is nog value in D2 or E2.
If the cells D2 ande E2 are empty I dont want it to give a result.

What do I need to change in the formula to get this to work?

 

[FormR]

If the cells D2 ande E2 are empty I dont want it to give a result.

Hi, you could like this:

=ALS(EN(D2="";E2="");"";ALS(D2="";"('"&A2&"', '"&TEKST(C2;"jjjj-mm-dd")&"', '"&E2&"'),";"('"&A2&"', '"&TEKST(C2;"jjjj-mm-dd")&"', '"&D2&"'),"))

 

[FormR]

And I think you can probably shorten the whole thing a bit like this:

=ALS(EN(D2="";E2="");"";"('"&A2&"', '"&TEKST(C2;"jjjj-mm-dd")&"', '"&ALS(D2="";E2;D2)&"'),")

 

[Edwin_SVRZ]

And I think you can probably shorten the whole thing a bit like this:

=ALS(EN(D2="";E2="");"";"('"&A2&"', '"&TEKST(C2;"jjjj-mm-dd")&"', '"&ALS(D2="";E2;D2)&"'),")

That's a lot shorter and it works perfectly.
Thanks !!