calculating positive and negative formulas

C

cliford

I am trying to do a budget worksheet. On one column I have totals added up
for expenses. On another sheet I have credit card payments & charges. If
charges exceed payments, then a negative number will result. How can I
include that number into my Expenses column & reflect the correct total,
whether its a positive or negative number?
 
I

Ian

I'm sure it's not as simple as it seems, but can you not just subtract or
add them as appropriate?
 
S

Sandy Mann

Cliford,

Do you mean that if the charges exceed the payment you want the negative
total added as a "positive" to the expenses total?

If so then try:

=Expenses Total + - Negative Total

it may be easier to read it as:

=Expenses Total + (- Negative Total)


--
HTH

Sandy
[email protected]
Replace@mailinator with @tiscali.co.uk
 
Top