Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 10
Default transfer stock on condition

Can someone help with a formula?
I want to use the transfer of stock between 3 shops, by checking a the cell
of Sale on each item, and then check the inventory cell if few or zero and
the same item available in other shop, will be transfer the appropriate
quantity.

Example 1:

shop1 shop2 shop3
Total QTY
sale inventory sale inventory sale inventory sale
inventory
2 9 10 1 4 0
16 10

shop1 to shop2 = 3 pcs
shop1 to shop3 = 3 pcs

to be similar to:

shop1 shop2 shop3
Total QTY
sale inventory sale inventory sale inventory sale
inventory
2 3 10 4 4 3
16 10

===================================
Example 2:


shop1 shop2 shop3
Total QTY
sale inventory sale inventory sale inventory sale
inventory
10 5 9 1 4 11
23 17

shop3 to shop2 = 5 pcs

to be similar to:

shop1 shop2 shop3
Total QTY
sale inventory sale inventory sale inventory sale
inventory
10 5 9 6 4 6
23 17


  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 10
Default post again

I do not know if the examples are clear or not, anyway examples here again

Example 1:

shop1,sale = 2 inventory = 9
shop2,sale =10 inventory = 1
shop3,sale = 4 inventory = 0
Total QTY,sale = 16 inventory = 10


Transfer:
shop1 to shop2 = 3 pcs
shop1 to shop3 = 3 pcs

to be similar to:

shop1,sale = 2 inventory = 3
shop2,sale =10 inventory = 4
shop3,sale = 4 inventory = 3
Total QTY,sale = 16 inventory = 10

===================================


Example 2:

shop1,sale = 10 inventory = 5
shop2,sale = 9 inventory = 1
shop3,sale = 4 inventory = 11
Total QTY,sale = 23 inventory = 17


Transfer:
shop3 to shop2 = 5 pcs

to be similar to:

shop1,sale = 10 inventory = 5
shop2,sale = 9 inventory = 6
shop3,sale = 4 inventory = 6
Total QTY,sale = 23 inventory = 17
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 10
Default post again

Up
--
Whatever you love doing. keep doing it.
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How many days the ready stock+expected stock will last as allocate Narnimar Excel Discussion (Misc queries) 0 September 16th 08 05:57 PM
lookup with multiple condition, but one condition to satisfy is en Eddy Stan Excel Worksheet Functions 2 October 27th 07 02:06 PM
Web Query With Multiple Stock Symbols & Stock Scouter Manfred Excel Worksheet Functions 0 March 1st 06 10:13 PM
How can I use Dutch (NL) stock MSN MoneyCentral Stock in Excel Jeroen Excel Worksheet Functions 0 February 16th 06 04:14 PM
Office 2003 Stock Action Add-In - Stock Handling Capacity/Numbers nick Excel Worksheet Functions 0 January 2nd 06 10:22 PM


All times are GMT +1. The time now is 11:34 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"