difference between two cells based on criteria in other cell

[n9zez]

Hello,

I haven't played around with Excel in many years so I am a bit rusty. Attached is a screen-shot of what I am trying to create to keep track of my monthly bills.

I need a formula that will allow the "Available" column to reflect the difference between the "Limit" column and the "Balance" cell. However, the "Available" column needs to change monthly based on the new "Balance" amount.

The Balance cell will be updated monthly according to my statement balance. It is not being subtracted from the payment cell. This was just shown for an example. Also, the Limit cell is fixed and will only change if the bank changes it.

Hopefully this makes sense as it seems kinda hard to explain.

[shg]

Welcome to the forum.

Please take a few minutes to read the forum rules, and then amend your thread title accordingly.

Thanks.

[n9zez]

Thanks, I did read the rules and couldn't come up with a better title in a short amount of words.

Perhaps you could suggest one?

[shg]

This is a moderated forum; there are many unmoderated forums to choose from. We're happy to have you here, and eager to help, but the onus to compose a meaningful, concise thread title falls to you.

[n9zez]

I just thought that since you have posted over 16,000 times you most likely have read a few thread titles.

I am asking you for help in properly naming my title as I cannot think of a good short title to explain the problem.

[n9zez]

Answer:

In G3 try.

=F3-LOOKUP(9.99999999999999E+307,J3:U3)

I think these are the right cell references, your use of merged cells makes it difficult to tell, you may have to alter them.

G3= Available
F3= Limit
J3:U3=Monthly Balances

Quickly and politely answered on another forum in less than 10 hours.

Thanks for the lesson in thread titles.

[shg]

You're welcome, I'm sure they will welcome you as a regular. Different forums cater to people seeking different things, so there are many to choose from.