Hi experts,
Can anyone help me complete this formula or provide the correct formula to perform similar action.

=IF(C9="Condition1",CONCATENATE("Text1 ",D9," Text2 ",TEXT(E9,"DD/MM/YYYY"),". Text3 ",F9," Text4 ",G9," Text5.") ,IF(C9="Condition2",CONCATENATE("Text1 ",TEXT(E9,"DD/MM/YYYY"),", Text2 ",D9," Text3 ",G9," to ",F9,"."),IF(C9="Condition3",CONCATENATE(G9," Text1 ",B6," Text2 ",F9," Text3 ",TEXT(E9,"DD/MM/YYYY"),”