Allocating Bills in Excel

[Summer]

Hi,

I need a formula where I can allocate cell E2 to the rest of the cells in column E. The catch is I need cell E2 to show a decrease in the amount if that makes sense.

 

[NARAYANK991]

Hi ,

I think what you want to do is not possible using a formula , since E2 cannot have data and a formula at the same time. Secondly , if the rest of the cells in column E are allocated the value in cell E2 using formulae , then when E2 is decreased , all the formulae will reflect the change.

What you want done is possible using VBA.

Can you manually enter the values which should be put in cells E3 through E16 ?

Narayan

 

[Summer]

Hi Narayan,

Thanks for your response. E2 is the contract I'm allocating from and E3 - E16 are contracts I'm allocating to. The allocation overall total amount will be $502,660 which will leave a remaining balance. I need for the remaining balance to show in E2. I hope this makes sense.

 

[NARAYANK991]

Hi ,

From what I see , is it that all positive amounts from column D appear in column E ?

The total of all these positive amounts is 502,660.

What amount should appear in E2 ?

Narayan

 

[Summer]

The amount that should appear in E2 is $2,654,656.

Once we allocate $502,660 to E3-E16 from E2 $3,157,315 the remaining balance would be $2,654,656 that needs to show in E2.

 

[NARAYANK991]

Hi ,

See if this does the job.

Narayan

 

[Summer]

Thank you Narayan!!! This is perfect. I truly appreciate your time and assistance!!