what function to be used
 

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: http://www.excelforum.com/member.php...o&userid=34651
View this thread: http://www.excelforum.com/showthread...hreadid=544229

what function to be used
 

You 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)

"Priscila" wrote in
message ...

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:
http://www.excelforum.com/member.php...o&userid=34651
View this thread: http://www.excelforum.com/showthread...hreadid=544229