Excel VBA-Personal Budget: Identifying text in a column...

[flotsam2004]

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

 

[George Nicholson]

I am not 100% sure where your PreviousTotal Due, Payments and Balance 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 the TotalDue,
otherwise return the TotalDue.
--

HTH,

George Nicholson

Remove 'Junk' from return address.

 

[flotsam2004]

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

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

 

[flotsam2004]

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

Any other ideas?

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