Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Creating a Custom Excel Function to Calculate Gini Coefficients | Excel Worksheet Functions | |||
Date & Time | New Users to Excel | |||
Hyperlinks using R[1]C[1] and offset function in its cell referenc | Excel Worksheet Functions | |||
Conversion | Excel Worksheet Functions | |||
HOW CAN I GET OFFICE 2003 EXCEL BASIC TO NEST FUNCTIONS LIKE EXCE. | Excel Worksheet Functions |