Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Inventory Control
Hi,
I am looking to have implement a simple inventory formula but i'm not sure how to get it done. Do I require an IF statement? Macro? I have 4 variables Total Ordered = TO Total Received = TR Need to Order = NO Stock = S I need to be able to have NO = TO - TR, at the same time, if there is a positive total in the Stock, I need NO to subtract the stock balance (and to not give me a negative number if I have no stock) so my Need to Order is an accurate total. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Inventory Control
If NO=TO-TR-S is negative, what should NO resolve to?
TP=100 TR=80 S=30 NO=? " wrote: Hi, I am looking to have implement a simple inventory formula but i'm not sure how to get it done. Do I require an IF statement? Macro? I have 4 variables Total Ordered = TO Total Received = TR Need to Order = NO Stock = S I need to be able to have NO = TO - TR, at the same time, if there is a positive total in the Stock, I need NO to subtract the stock balance (and to not give me a negative number if I have no stock) so my Need to Order is an accurate total. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Inventory Control
I would prefer NO to report zero if there is no stock/nothing to
order. Does that make sense? On Jul 12, 9:54 am, Toppers wrote: If NO=TO-TR-S is negative, what should NO resolve to? TP=100 TR=80 S=30 NO=? " wrote: Hi, I am looking to have implement a simple inventory formula but i'm not sure how to get it done. Do I require an IF statement? Macro? I have 4 variables Total Ordered = TO Total Received = TR Need to Order = NO Stock = S I need to be able to have NO = TO - TR, at the same time, if there is a positive total in the Stock, I need NO to subtract the stock balance (and to not give me a negative number if I have no stock) so my Need to Order is an accurate total. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Inventory Control
try:
in C2: =MAX(A2-B2-D2,0) A2=TP B2=TR C2=NO D2=S " wrote: I would prefer NO to report zero if there is no stock/nothing to order. Does that make sense? On Jul 12, 9:54 am, Toppers wrote: If NO=TO-TR-S is negative, what should NO resolve to? TP=100 TR=80 S=30 NO=? " wrote: Hi, I am looking to have implement a simple inventory formula but i'm not sure how to get it done. Do I require an IF statement? Macro? I have 4 variables Total Ordered = TO Total Received = TR Need to Order = NO Stock = S I need to be able to have NO = TO - TR, at the same time, if there is a positive total in the Stock, I need NO to subtract the stock balance (and to not give me a negative number if I have no stock) so my Need to Order is an accurate total. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Inventory Control | Excel Worksheet Functions | |||
inventory control | Excel Worksheet Functions | |||
Inventory Control | Excel Discussion (Misc queries) | |||
Inventory Control | Excel Worksheet Functions | |||
inventory control in excel | Excel Discussion (Misc queries) |