Add formula for multiple recurrence to VB Code

[manju 3]

Hi Team, I have 3 columns A,C and F. Based on A and C, i am writing the formula for adding F cells together in the Output cell. I have the formula written for output column as

=IF($A1=0,F1,
IF($A1=1,IF(C1=4,F1 &CHAR(10)& F2 &CHAR(10)& F3 &CHAR(10)& F4,
IF(C1=3,F1 &CHAR(10)& F2 &CHAR(10)& F3,
IF(C1=2,F1 &CHAR(10)& F2,""))),""))

Its working fine as below:

A C F output
0 1 a a
1 2 b bc
2 2 c
1 3 d def
2 3 e
3 3 f

Can someone help me how can i add the formula in loop to check for C1>4 like and go on for if more values :

IF($A1=1,IF(C1=5,F1 &CHAR(10)& F2 &CHAR(10)& F3 &CHAR(10)& F4 &CHAR(10)& F5,
IF($A1=1,IF(C1=6,F1 &CHAR(10)& F2 &CHAR(10)& F3 &CHAR(10)& F4 &CHAR(10)& F5 &CHAR(10)& F6,
IF($A1=1,IF(C1=7,F1 &CHAR(10)& F2 &CHAR(10)& F3 &CHAR(10)& F4 &CHAR(10)& F5 &CHAR(10)& F6 &CHAR(10)& F7,

Great thanks Manju