Another Tally question...

Giganews Newsgroups
Subject: Another Tally question...
Posted by:  onesidered (onesidered.29enko_1150310402.9748@excelforum-nospam.com)
Date: Wed, 14 Jun 2006

I have data in cells C4:C27
The data is equivilant to Dollars and cents
I have the budget amount at the bottom of my worksheet as $5,000
As I input data into the C column, it updates the bottom # by
subtracting from it.
Example: $50 in C updates total to -$4950

My question - I am currently using this formula =SUM(C4:C27)-5000 and I
would like for my $5000 to be a positive number instead of -$5000.  Then
when I go over that amount it will turn into a negative number. Can
anyone help?

I should be able to figure this out, but I have brain fry today.

Thanks,
T.

--
onesidered
------------------------------------------------------------------------
onesidered's Profile:http://www.excelforum.com/member.php?action=getinfo&userid=25977
View this thread:http://www.excelforum.com/showthread.php?threadid=551977

Replies