Excel 2007 : Excel Formula To Deduct Outstanding Balance from Seperate Cell

Hi

I have added a formula to your sheet, please have a look to see if it fulfills your requirements.

Regards

Jeff

Hi Jeff

Brilliant work. Is there any chance formula in Tax Sheltered Distribution cell can be altered so as to distribute any remaining fund even if this is less than the shortfall in income.

HI

If you change the values for both funds to e.g. 10,000 you will see that both are fully distributed with a shortfall remaining of 8,377.

Was there something different that you wished to achieve?

Regards

Jeff

Attach revised spreadsheet incorporating your formulas in cells T10 & U10, which I have copied to the cells directly below.

Cells T10 and below work perfectly with the outstanding balance deducted in cell U14. Cells U15 & U16 also work fine. However, as you can see £0 appears in cell U17 despite there being still £26,270 remaining in cell H17. Need the formula to deduct remaining balance of £26,270 in cell U17 even though it has a lower value than the shortfall.

The revised formula needs to be entered in cells U10 to U40 as beginning balances, annual target income and net income received will vary from client to client.

Hi

Sorry, my mistake, the cell reference was incorrect in the last part it referred to column G instead of column H.

Attached is the revised version.

Regards

Jeff

Thanks Jeff. Works perfectly.