Balance b/f to be offset if payment made

**kenjichan** · 05-26-2014, 02:25 PM

Hi,

Need help urgently...

My boss was assigned new tasks for me to determine some amount which been provided last year and need to offset the amount if the payment made this year.
Sample as attached:
Workbook1.xlsx

Your help is much appreciated

**alansidman** · 05-26-2014, 03:11 PM

In D18, use this formula. =IF(D11<SUM(C3:D3),D11,SUM(C3:D3))

Then adapt its syntax for your remaining cells requiring a formula.

**kenjichan** · 05-31-2014, 11:57 AM

Thanks so much and its work...

Balance b/f to be offset if payment made

LinkBack

Thread Tools

Rate This Thread

Display

Balance b/f to be offset if payment made

Re: Balance b/f to be offset if payment made

Re: Balance b/f to be offset if payment made

Thread Information

Users Browsing this Thread

Similar Threads

Entering a payment and seeing a new balance

Running Balance Payment Formula

Calculation Of Last Payment Made

[SOLVED] formulating a balance when a loan payment is made

Retrieving the Most Recent Payment Made by Client

Bookmarks

Bookmarks

Posting Permissions