vaidmohammed
Member
Hi,
I have an excel where i have to maintain month wise budget amount utilized and also need to keep a track of percentage of budget utilized. I tried concatenate function, but it didn't work. Can you please advise me a formula to derive the values as shown in attached excel Row# 4 (this is how the figures needs to be shown).
Row# 2 shows the budget available for the month, which is derived with a formula.
Row# 3 shows the percentage of funds utilized for each month on cumulative basis.
Row# 4 shows the budget available for the month and percentage of funds utilized till this month.
Here i am not able to derive a formula for Row# 4, where i seek your help
I have an excel where i have to maintain month wise budget amount utilized and also need to keep a track of percentage of budget utilized. I tried concatenate function, but it didn't work. Can you please advise me a formula to derive the values as shown in attached excel Row# 4 (this is how the figures needs to be shown).
Row# 2 shows the budget available for the month, which is derived with a formula.
Row# 3 shows the percentage of funds utilized for each month on cumulative basis.
Row# 4 shows the budget available for the month and percentage of funds utilized till this month.
Here i am not able to derive a formula for Row# 4, where i seek your help