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.

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.

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.

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.