This is what I am trying to calculate. I have a ticketing program that
customer requests automatically goes into. Here is the quarkiness part
of the program the ticketing program stops at 999 then resets at 001.
So for example day before yesterday the ticket system was at 840 and
yesterday's tickets were at 980 and today tickets system is at 100. So
what I have is formula that subtracts 980-840=140 tickets for that day
[=SUM(b1-a1)]. So what I am trying to do is calculate how many tickets
I had for that day. Now here is the problem I can't seem to resolve.
is when the system today reached at 100 how do I calculate that?
100-980=??? is not going to work. So I need some kind of IF THEN
statements or some other way of calculating that. Currently I do it
manually, but need to automate this to save time. Let me know if
someone has any idea.

Thanks in Advance

Dham


--
dhampatel
------------------------------------------------------------------------
dhampatel's Profile: http://www.excelforum.com/member.php...o&userid=35690
View this thread: http://www.excelforum.com/showthread...hreadid=554755