Excel spreadsheet help please

Andybtsn

Andybtsn

Andybtsn

Don
Joined
23 Oct 2005
Posts
44,336
Location
North Yorkshire
Hey,

I'm currently creating a spreadsheet for myself with my month outgoings...

I have in the left column my outgoings and then in the value in the next column.

I'd like credit's (+) to show as green and debit's (-) to show as red. How do I create something to do so? Will it be an IF function? If so, how do I do this on the value?

All the value's are set to currency.

Thanks!
 
Just another query.

I have my grand total for my outgoings for the month at the end of the page.

I want a sum that tells me how much I have left for the month from a certain value.

So say my outgoings result to say £750. How do I do a sum, that minus' that from £1000 a month that I allow myself?

So I want on my spreadsheet

Total: £750
Leaves me for end of month £250

How do I automatically have a sum setup so everytime I unput an outgoing payment it adjusts how much I have left every month?

Thanks!
 
In the cell you want the result do:

=SUM(A1-A2)

Change A1 and A2 to the cells that have you values.

TrUz
 
You must log in or register to reply here.
Back
Top Bottom