Breaking Total Amount Monthwise

[Venkata Ramanaji]

Hi All

Good day

Please find the attached file for my query.

I have data in Column A and Column B.

Column A is Total Amount

Column B is No of Months

Column C to Column N are the Months

Now, the requirement is if the Column B is 12, the Total Amount to be divided equally from Column C to Column N

and

if the Column B is 10 , the Total amount is divided equally from Column C to Column L

and

if the Column B is 3, the Total Amount is divided equally from Column C to Column E

and

Likewise for the otherwise others

Hope you guys could be of help for me.

Thanking you in advance.

Regards
Ramana

 

[AliGW]

In C3 copied across and down:

=IF(COLUMNS($C2:C2)<=$B3,$A3/$B3,"")

 

[Venkata Ramanaji]

Hello Mam

Thank you very much . It is working fine

Learnt a new thing from you.

Regards
Ramana

 

[AliGW]

Great - glad to help.