calculating positive and negative formulas
 

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'm sure it's not as simple as it seems, but can you not just subtract or
add them as appropriate?

--
Ian
--
"cliford" wrote in message
...
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?

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

Replace@mailinator with @tiscali.co.uk


"cliford" wrote in message
...
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?