software

My queire is
There are many customers and each customer can purchase limited amount
of quantity in a year as per govt rules. these customers purchase
monthly or quarterly, etc., a particular quanity.

i want to calculate in such a way that
if i enter a customer name in one cell and the quantity purchase in
that particular month in another cell, the third should show the
balance amount of quantity that can be purchased by the particular
customer (balance quantity that is liable to be purchased).

please help me how to do the above,

thanks
Priscila--
Priscila
------------------------------------------------------------------------
Priscila's Profile: www.excelforum.com/member.php...oamp;userid=34651
View this thread: www.excelforum.com/showthread...hreadid=544229You need to lookup up the allowable amount for the customer (see VLOOKUP),
and subtract the actual from that.

--
HTH

Bob Phillips

(remove xxx from email address if mailing direct)

quot;Priscilaquot; gt; wrote in
message ...
gt;
gt; My queire is
gt; There are many customers and each customer can purchase limited amount
gt; of quantity in a year as per govt rules. these customers purchase
gt; monthly or quarterly, etc., a particular quanity.
gt;
gt; i want to calculate in such a way that
gt; if i enter a customer name in one cell and the quantity purchase in
gt; that particular month in another cell, the third should show the
gt; balance amount of quantity that can be purchased by the particular
gt; customer (balance quantity that is liable to be purchased).
gt;
gt; please help me how to do the above,
gt;
gt; thanks
gt; Priscila
gt;
gt;
gt; --
gt; Priscila
gt; ------------------------------------------------------------------------
gt; Priscila's Profile:
www.excelforum.com/member.php...oamp;userid=34651
gt; View this thread: www.excelforum.com/showthread...hreadid=544229
gt;