Excel formula problem for personal budget

[flotsam2004]

Brought over from the Programming forum:

Posted by flotsam2004 on 04-21-2004 05:04 PM:
Excel VBA-Personal Budget: Identifying text in a column...

Identifying text in a column, reading a sum in the next column an
subtracting that number from a cell with the total.

For instance:
If one of the cells from A2:A10 = "Visa Payment" then subtract (an
here's where I get lost) the sum ($$ payment) from the correlating cel
in column B from a cell with the total.

I have the columns named: Date, Debtor, Payment and Total Due.

Any ideas? I think it's a simple IF, THEN, ELSE formula, but I can'
get my brain around it.

Thanks.


--------------------------------------------------------------------------------
Posted by George Nicholson on 04-21-2004 06:20 PM:
Re: Excel VBA-Personal Budget: Identifying text in a column...

I am not 100% sure where your PreviousTotal Due, Payments and Balanc
Due
amounts are/should go, but maybe this will help:

CurrentBalance=IF(COUNTIF(A2:A10,"=VisaPayment")>0,TotalDue-PaymentAmount,To
talDue)

If there has been a VisaPayment, subtract the Payment from th
TotalDue,
otherwise return the TotalDue.
--

HTH,

George Nicholson

Remove 'Junk' from return address.


message

Identifying text in a column, reading a sum in the next column and
subtracting that number from a cell with the total.

For instance:
If one of the cells from A2:A10 = "Visa Payment" then subtract (and
here's where I get lost) the sum ($$ payment) from the correlatin cell
in column B from a cell with the total.

I have the columns named: Date, Debtor, Payment and Total Due.

Any ideas? I think it's a simple IF, THEN, ELSE formula, but I can't
get my brain around it.

Thanks.

--------------------------------------------------------------------------------
Posted by flotsam2004 on 04-21-2004 07:36 PM:
budget.xls example of waht I'm looking for.

Could it be accomplished with an excel formula instead of VBA code?


--------------------------------------------------------------------------------
Posted by flotsam2004 on 04-21-2004 09:12 PM:
Still no success with this formula

Attached is the .xls with the suggested formula, but I can't seem t
get it to function properly.

Any other ideas

Attachment filename: budget.xls
Download attachment: http://www.excelforum.com/attachment.php?postid=52287

 

[Guest]

This formula that your trying to write, does it get copied/pasted on every row of your data, or is it down at the bottom

=if(A2="Visa Payment",b2-$a$1,0

----- flotsam2004 > wrote: ----

Brought over from the Programming forum

Posted by flotsam2004 on 04-21-2004 05:04 PM:
Excel VBA-Personal Budget: Identifying text in a column..

Identifying text in a column, reading a sum in the next column an
subtracting that number from a cell with the total

For instance
If one of the cells from A2:A10 = "Visa Payment" then subtract (an
here's where I get lost) the sum ($$ payment) from the correlating cel
in column B from a cell with the total

I have the columns named: Date, Debtor, Payment and Total Due

Any ideas? I think it's a simple IF, THEN, ELSE formula, but I can'
get my brain around it

Thanks


-------------------------------------------------------------------------------
Posted by George Nicholson on 04-21-2004 06:20 PM:
Re: Excel VBA-Personal Budget: Identifying text in a column..

I am not 100% sure where your PreviousTotal Due, Payments and Balanc
Du
amounts are/should go, but maybe this will help

CurrentBalance=IF(COUNTIF(A2:A10,"=VisaPayment")>0,TotalDue-PaymentAmount,T
talDue

If there has been a VisaPayment, subtract the Payment from th
TotalDue
otherwise return the TotalDue
-

HTH

George Nicholso

Remove 'Junk' from return address


messag

Identifying text in a column, reading a sum in the next column an
subtracting that number from a cell with the total
If one of the cells from A2:A10 = "Visa Payment" then subtract (an
here's where I get lost) the sum ($$ payment) from the correlatin cel
in column B from a cell with the total

-------------------------------------------------------------------------------
Posted by flotsam2004 on 04-21-2004 07:36 PM:
budget.xls example of waht I'm looking for

Could it be accomplished with an excel formula instead of VBA code


-------------------------------------------------------------------------------
Posted by flotsam2004 on 04-21-2004 09:12 PM:
Still no success with this formul

Attached is the .xls with the suggested formula, but I can't seem t
get it to function properly

Any other ideas

Attachment filename: budget.xls
Download attachment: http://www.excelforum.com/attachment.php?postid=52287