total column to minus what is in the debit Col (E) & add the Credit col (D)

**blue elephant** · 11-09-2008, 05:12 PM

Hi, i'm using excel to create a spreadsheet to keep a track of my accounts but am struggling to come up with a formula which is probably really simple but i just can't seem to get in right.

I have a credit column, a debit column & a total column.

I want the total column to minus what is in the debit column (column E) & add what is in the Credit column (column D).

This os driving me insane as I use excel quite a lot but can't do this...heeeelp!!!

Thanks

**Simon Lloyd** · 11-09-2008, 05:16 PM

Assuming F is your total column and F1 your starting value =F1+D2-E2 why not attach a workbook?

**blue elephant** · 11-09-2008, 05:27 PM

That's great thank you. Now just gotta figure out how to make any numbers showing in a minus figure turn red in colour.

**VBA Noob** · 11-09-2008, 05:33 PM

Take a look at custom formats

http://peltiertech.com/Excel/NumberFormats.html

e.g

0;[Red]-0

or conditional formats
http://www.contextures.com/xlCondFormat01.html

VBA Noob

**Simon Lloyd** · 11-09-2008, 05:55 PM

Its simpler than that, just right click the cell choose format cells>number then choose the look you want for anegative number!

**blue elephant** · 11-09-2008, 06:04 PM

Thanks Simon, you've been a great help.

**Simon Lloyd** · 11-09-2008, 06:09 PM

If this has answered your question please mark the thread solved by going to your first post in this thread then EDIT>GO ADVANCED you will see a dropdown next to the title choose Solved and then save changes!

total column to minus what is in the debit Col (E) & add the Credit col (D)

LinkBack

Thread Tools

Rate This Thread

Display

total column to minus what is in the debit Col (E) & add the Credit col (D)

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions