Thread
:
calculating positive and negative formulas
View Single Post
#
1
Sandy Mann
Posts: n/a
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?
Reply With Quote