ORDER SUPPLIES

  • Thread starter Thread starter NannaLuvs
  • Start date Start date
N

NannaLuvs

COL 1 SUPPLY COL 2 #in stock
col1=<1> enter #2 so I can order supply or enter the word order
I don't know if I should just do a query, or what if function or what, but I
want it simple.
thanks
 
You are too vague in your request so this is jst a guess -
A B C
Supply InStock Availability
1 2 1
2 0 Out of Stock


formula for Column C

=If(B2-A2>1,"Out of Stock",B2-A2)






whereas ReOrder will be the qty of stock already supplied.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

tiny discrepancies in fixed-point numbers 3
info mtg criteria from one wkbk to another 2
Vlookup with 2 different criteria before inserting a value 15
Can I use "OR" in two auto-filters/custom filters? 1
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
Problem formula 3
Comparison of columns and calculate differences 1
Number to equivalent Letter 3

Back
Top