calculating positive and negative formulas

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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
(e-mail address removed)
Replace@mailinator with @tiscali.co.uk
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Subtracting positive amts from negative and positive from positive 3
formula in excel 2
changing numbers from positive to negative in a sheet 3
CONDITIONAL FORMATTING & NEGATIVE VALUES 1
subtract a positive from a negative 7
Negative Numbers in a Pivot Table 1
calculating total in a column 2
Change positive to negative number 4

Back
Top